Importing Data

H

hughess7

I have a master database which is 'cloned' and data for different dealers is
entered in each container (clone db) separately. I now want to import all
clone db's data back into the master database. I have set up a macro which
imports one at a time and appends the data to existing tables. This all works
fine but I have approx 150 to do and wandered if there was any easy way of
automating this? The problem is all the database names are different - is
there anyway of getting access to read files sequentially from explorer
somehow to feed in the source date?
 
J

John Vinson

I have a master database which is 'cloned' and data for different dealers is
entered in each container (clone db) separately. I now want to import all
clone db's data back into the master database. I have set up a macro which
imports one at a time and appends the data to existing tables. This all works
fine but I have approx 150 to do and wandered if there was any easy way of
automating this? The problem is all the database names are different - is
there anyway of getting access to read files sequentially from explorer
somehow to feed in the source date?
Click to expand...

Not in a Macro, but you can use the Dir() function in a VBA module.
See the online help and example for Dir() in the VBA help.

John W. Vinson[MVP]
 
Top