Using ADO With Excel

G

Guest

Hi I use Excel a lot with MSAccess in Access I have modules with VBA code
that run importing text files into an Access dB, what I want to know is can
these procedures be run using ADO I don't want to create an instance of
Access because the network don't support it can this be done with ADO. I am
now moving over from DAO to ADO but finding all that ADO has to offer take a
while so if someone can help it would be much appreciated thanks.
Frank
 
K

keepITcool

ADO can access the DATA in the mdb,it cannot replace MsAccess.. and run
the code in the MDB.

However you can put the (modified) code in Excel and use ADO to read
the textfiles and insert the data into tables in the MDB.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Frank wrote :
 

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

Help With ADO 1
retreive Access via ADO 2
Shared folder changed path - sometimes S://SharedFolder sometimes T://SharedFolder 8
Counting Access recordset to import to Excel using ADO 5
using ADO from Excel 2007 1
Manipulating MS Access records with excel VBA + ADO 7
ADO versus VBA 13
Import MS Access data into MS Excel using VBA... 6

Top