Import multiple files from one location to new tables

[shmalex007]

Hi there can anyone help me out with a VBA code for the following:


I have a directory with 300+ .xls files in it - all of different file names, and I want to import all of these files into the same Access database but each into a new table as each is formatted differently.
The table name in Access should be the same as the .xls file name
I am using Access 2010 and have tried various loops and nothing seems to be working.
Please help! Alex

[June7]

Google: Access VBA import excel
Here is one
http://social.msdn.microsoft.com/For...6-e3a7a1484f65