Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using ADO With Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using ADO With Excel
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 : 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|