<
[email protected]>
<
[email protected]>
<
[email protected]>
<
[email protected]>
<
[email protected]>
<
[email protected]>
Newsgroups: microsoft.public.word.docmanagement
NNTP-Posting-Host: 159.205.76.83.cust.bluewin.ch 83.76.205.159
Lines: 1
Path: number1.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!msrtrans!TK2MSFTFEEDS01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
Xref: number1.nntp.dca.giganews.com microsoft.public.word.docmanagement:218007
Hi Greg,
If any pros are reading I would appreciate it if you could
point me to some online references for reading up on establish
connections between Word and other Office applications.
It depends on the application
ADO, as in the sample code you
post, depends on an OLE DB connection; the application must
supply an "OLE DB provider". In Office, only Access does this;
the Access provider also works with Excel. For any other
application, you have to use automation.
The other possibility is a DAO connection. DAO is the native
Access/Jet engine "language". The syntax is similar to ADO, but
not exactly the same. DAO tends to be slightly more reliable
with Excel than ADO, IMO. And you can certainly accomplish tasks
that manipulate an Access database structure (as opposed to just
the data) more easily with it than with ADO. (Of course, since
it's "native".) DAO also provides an interface for connecting to
other data sources using ODBC, via that database's ODBC driver.
Information on DAO can be found in the Access Help files. Most
(older) advanced Access books (such as those by Ken Getz) also
cover using DAO.
There's a data.ado newsgroup if you want to delve into ADO.
Basic connection information (strings) can be found here:
http://www.carlprothman.net/
If you're really interested, and can get hold of it, "ADO
Examples and Best Practices" from a!press, by Vaughn, is a very
useful resource.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8
2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail