transfer data into an external database
- From: "Alan UK" <alanuk@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2005 08:41:06 -0700
I have a database that contains large tables (BigTables.mdb) and a module to
import a csv file using an import specification.
I want to run this module and populate this database by running code in a
different database (Control.mdb) where the queries on the tables sit. To be
clear I want to refresh BigTables.mdb with the csv file, not Control.mdb
I understand the code that calls queries in the external database using DAO,
and have tried to call the module using a similar technique and placing a
reference to BigTables.mdb into Control.mdb
Dim db As DAO.Database
Set db = DBEngine.Workspaces(0).OpenDatabase _
("D:\BigTables.mdb")
BigTables.[test2].Importatron1
Set db = Nothing
Unfortunately this runs the import into Control.mdb, so I get a new and
unwanted table there instead of in BigTables.mdb.
Can someone please tell me where this is going wrong, or if another method
is more appropriate?
Thanks for your assistance
[*Please* don't refer me to any help files on this matter, however, as
neither my machine at home nor at work seems to be able to access these help
files. I have checked
MS DAO 3.6 Object Library and
MS ADO Ext. 2.5 DLL for Security
in the object library references - is there something else that needs a
check before this will work or the help files are viewable for related topics?
I apologise that this was also posted elsewhere, but failed to get a
response that helped]
.
- Follow-Ups:
- Re: transfer data into an external database
- From: John Nurick
- Re: transfer data into an external database
- Prev by Date: RE: Export to textfile
- Next by Date: Re: How to avoid connection popup?
- Previous by thread: Transfer text/spread*** to Access
- Next by thread: Re: transfer data into an external database
- Index(es):