Greetings all.

As a relatively new to programming person, I wonder if anyone out there can give me a few pointers to a problem I have.

I have a client who does some testing with a piece of equipment that creates an Access2000 database with each test run. Depending upon time and distance of test, the databases can range from just a few records to many hundreds. They have just completed a relatively large testing schedule, and have close to 700 different databases. The idea is to now get all of that data from each database into a new database.
I can do it manually, but imagine that it would take me the rest of the year to complete.
Any thought as to how I can write some code to go through interrogating each database, and appending into a single table?

Thanks in advance.

NeillG

what are the names of databases created are those names in a sequence like db1, db2, db3 ...... or names are different

tell me the names of databases and also the table names from which data is to be collected along with field names if possible upload a sample

what are the names of databases created are those names in a sequence like db1, db2, db3 ...... or names are different

Also tell the names of tables and their fields from which data is to be collected

if possible upload a sample

Greetings khawar

Thanks for your response.
Have attached a sample for you as requested.
You will see that the names of databases relate to roads. Each test is done both ways, so we have the name of each road twice ( 1 & r).

Thanks again


NeillG

Cant see any attachment

Cant see any attachment

Sorry, will try again.