Append Multiple Acess data base files together

  • Thread starter Thread starter R Mundroff
  • Start date Start date
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.
 
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.
 
Back
Top