Re: access Oracle database from Word for Mac

Tech-Archive recommends: Fix windows errors by optimizing your registry

Peter Jamieson wrote:

> "Marco" <marco@xxxxxxxxxxx> wrote:

> >I want to access an Oracle database via some userforms I created in Office
> > for Mac 2004.

> 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).

MS Word for OS X does not support ODBC, although MS Excel does. We
have several customers who use Excel to query Oracle for data, save the
resulting spread***, and then use Word to mail merge with the
spread***. While not as convenient accessing the database directly
from Word, using Excel as an intermediary usually isn't too bad. This
process can be automated, especially with the Excel "QueryTables" VBA
object.

Jonathan Monroe
Actual Technologies - ODBC for OS X
http://www.actualtechnologies.com
monroej@xxxxxxxxxxxxxxxxxxxxxx

.

Quantcast