Re: access Oracle database from Word for Mac

I tried using that ODBC driver before. Word 2004 simply does not have the
features to use ODBC as mailmerge datasource.

Peter,

I came to the same conclusion: automating Excel.
Since the Office environment on Apple is not very stable, I have my doubts
about automating applications and exchanging data.

I don't think this will work as you'd expect it to work. I talked to some
specialists and they told me that there were 2 good alternatives to access
these databases:

1. Realbasic
http://www.macworld.com/news/2005/06/14/realbasic/index.php?lsrc=mwrss

This seems a perfect solution, but you'll have to pay for this one.

2. use JAVA applications and JDBC to access the Oracle database and open the
correct template to supply it with the necessary data from the DB or use a
temp-datafile that you can pick up with your VBA code

gr. Marco
"Peter Jamieson" <pjj@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23HMjsPKeFHA.720@xxxxxxxxxxxxxxxxxxxxxxx
> Unfortunately I do not have an answer for you, but since no-one replied I
> wonder if you managed to make any progress on this one.
>
> On the Mac front I'm a newbie and am still very ignorant about what is and
> is not feasible/straightforward etc.. As far as Word VBA is concerned, the
> Mac VBA documentation discusses calling Mac "Code resources" as the
> equivalent of calling routines in Windows .dll s, but I get the impression
> that that option was only available in Mac Classic, not Mac OSX. Maybe
> someone can confirm/deny.
>
> I also hoped it might be possible to connect to an ODBC mailmerge data
> source and manipulate data using the (limited) facilities of the
> MailMerge.Datasource object, but none of the Word data connection dialogs
> suggest that there is any support for such connections any more (although
I
> think I found sometthing in Help that suggested they might be) and my
> attempts to make them using OpenDataSource have failed so far. Maybe
someone
> can confirm/deny whether that is feasible or not. (FWIW I have Office 2004
> here but would be interested in any relevant info. on other Mac versions).
>
> If neither of those is feasible, and an Applescript approach is also
> infeasible, the only other approach I can think of would be to access your
> Oracle data by Automating Excel, which /can/ access ODBC data sources via
MS
> Query - assuming, of course, that you have installed the necessary ODBC
> stuff & Oracle drivers on the system.
>
> I have to assume that anyone in the Mac environment who needs to do this
> kind of thing basically chooses a completely different approach from
> Word+Automation.
>
> Peter Jamieson
>
>
> "Marco" <marco@xxxxxxxxxxx> wrote in message
> news:%23lk6aO5aFHA.2980@xxxxxxxxxxxxxxxxxxxxxxx
> >I want to access an Oracle database via some userforms I created in
Office
> > for Mac 2004.
> >
> > We use to do this via DAO or ADO when developing for Windows. Can
anybody
> > advise me how I can best access an Oracle databse from VBA on the Mac?
> >
> > thanks,
> > Marco
> >
> >
>
>



.

Relevant Pages

  • Re: fields queries and utter disaster
    ... I suspect that regrettably, in this case the Excel team got to it, the Word ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • Re: ODBC connection to mdb for MacIntosh
    ... > Microsoft Access does not exist for the Mac. ... As long as the computer has ODBC drivers for an Access ... You can use the MS Query interface to create any SQL command ...
    (microsoft.public.mac.otherproducts)
  • Re: access Oracle database from Word for Mac
    ... Mac VBA documentation discusses calling Mac "Code resources" as the ... Oracle data by Automating Excel, which /can/ access ODBC data sources via MS ...
    (microsoft.public.mac.office.word)
  • Re: access Oracle database from Word for Mac
    ... > features to use ODBC as mailmerge datasource. ... >> that that option was only available in Mac Classic, ... >> can confirm/deny whether that is feasible or not. ... >> Peter Jamieson ...
    (microsoft.public.mac.office.word)
  • Re: ODBC connection to mdb for MacIntosh
    ... >>> Microsoft Access does not exist for the Mac. ... In order to use ODBC ... >>> the data tables (the .mdb file) has to reside on a Windows computer that ... As long as the computer has ODBC drivers for an Access ...
    (microsoft.public.mac.otherproducts)
Loading