By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

How to import multiple access files into one file

P: 2
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!
Jul 13 '10 #1
Share this Question
Share on Google+
3 Replies


beacon
100+
P: 579
Do you want to automate it or do you want to import the files manually?
Jul 13 '10 #2

P: 2
If it can be automated, that would be fantastic...otherwise I manual importing is fine.
Jul 13 '10 #3

beacon
100+
P: 579
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).
Jul 14 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.