Greetings all.
Very new to this, please excuse any errors.
I have been given a series of created databases, A total of not quite 700 ( seven hundred). They are created through a piece of testing equipment, and will write an identical single table to a new database for every test that is run.
My question is to seek advise/help on perhaps writing some form of code that will interigate each database in the sequence they were created, and append all the data from all the databases, into a single database.
The original data is a MSAccess2000 format, and I am working with a Acces2003 application.
Any help, or pointers in the right direction would be greatfully accepted.
Thanks
NeillG
Very new to this, please excuse any errors.
I have been given a series of created databases, A total of not quite 700 ( seven hundred). They are created through a piece of testing equipment, and will write an identical single table to a new database for every test that is run.
My question is to seek advise/help on perhaps writing some form of code that will interigate each database in the sequence they were created, and append all the data from all the databases, into a single database.
The original data is a MSAccess2000 format, and I am working with a Acces2003 application.
Any help, or pointers in the right direction would be greatfully accepted.
Thanks
NeillG