Append Multiple Acess data base files together

R

R Mundroff

I have a test machine that creates a new database file
every day. I want to Append 1 month's worh of data into 1
database file (Appox 30 files). Is there a easy way of
doing this with out opening eaxh file?

All tables & fields are the same in all databases.

Worst case scenario open every file and cut & pastse into
1 file.
 
D

Douglas J. Steele

Create a master database, and link to each of the 30 databases.

Alternatively, you can import each of the 30 database into one.

Both actions are done through the File | Get External Data menu option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top