Combining databases

[jhablitzel]

I have a radio automation application that stores a log file of items that have played. The log file is an Access '97 compatible MDB file. The problem is that is stores each days log in a separate MDB with the date as the file name. There is only one table in the MDB and it has the same format every day. I would like to combine these into one large database that contains a year of logs which would then allow me to write some custom reports against the data. I'm pretty familiar with Access and have done quite a bit of VBA code and a couple of different Access applications, but I can't for the life of me figure out how this could be done. Any ideas?

 

[KenReay]

Hi

Basically an INSERT INTO statement should do what you want. Would need to know more about naming convention of mdb's etc before venturing more detailed information on how to do it.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Remou]

If you open an Append query, you will find that it will allow you to append to a table in another database. Alternatively, you can import the tables using DoCmd.TransferDatabase. Once the tables are imported, a Union query will allow you to join the tables.