How to import multiple access files into one file

[pgathens]

This may sound like a very simple task for most, but it is not one that I find easy.

I am trying to take multiple (around 30 or so) MS Access 2003 files and throw the data into a single access, or excel file.

All the files are identical in formatting, and this is something that will be done on an almost daily basis.

Please help if you can.

Thanks!

[beacon]

Do you want to automate it or do you want to import the files manually?

[pgathens]

If it can be automated, that would be fantastic...otherwise I manual importing is fine.

[beacon]

Check out this LINK. It gives you a solution to copy an ADO recordset to Excel.

You could create a VBScript executable file that does the same thing and then setup a Windows scheduled task to run the file at whatever time you want. This would probably be the best option for you because you could set it up and then never have to touch it again (unless you're on a network or have a password assigned to your profile that changes...you'd have to change the password stored in the scheduled task each time your login password changes).