transfertext

[bjdobs]

I am currently using this function successfully from a vba module to upload
CSV files into a database file in Access XP ... I would however like to
instead of having the csv files populate the current db (where I have the
Import function) , have them import to an external (split) database ... what
I have working so far is I have created a blank database and would like to
use the transfertext function if possible to upload into this blank database.
The concept that I am confused about is transfertext states it imports to the
currentdb ... it is not clear if I can tell vba to either say that the new
database is now the currentdb or tell transfertext to use a non current db
for its destination.

Could someone please clarify if this is possible or do I have to iterate the
CSV files and create the non currentdb tables via SQL statements

 

[Allen Browne]

If you link the CSV file, i.e.:
File | Get External | Link
you will be able to write the data into another database with a Make Table
query such as this:
SELECT * INTO Table1 IN 'C:\MyFile.mdb' FROM Table1;