Excel/Access connection via ADO

L

Loane Sharp

P.S. I'm a beginning Access VBA user, but an intermediate Excel VBA user.
Under time pressure I've decided to "drive the car" from within Excel rather
than Access (since I'm dealing with data analysis and interpretation rather
than database storage) and to focus on ADO- rather than DAO-based
connections between the two applications (since ADO seems to be the wave of
the future). Is this reasonable?
 
K

K Dales

Yes, it is reasonable and wise - DAO is now basically
obsolete. I also use ADO often to import Access (and
other db) info into Excel for more intensive numerical
analysis. With ADO you can even write Excel User
Functions based on your Access data.

For info on ADO you can go to the MSDN Library Data Access
Technologies section:
http://msdn.microsoft.com/library/default.asp?
url=/nhp/default.asp?contentid=28001860
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

retreive Access via ADO 2
Excel VBA via ADO connection 7
Excel/Access connection via ADO 1
ADO Recordset to Excel 2007 Worksheet Cell Values via XML 5
ADO connection Open failure 5
Excel as a front end to an Access database 1
Excel connect/import Access data using ADO and VBA? 4
Slow running SQL via ADO connection in excel 2

Top