Import multiple excel worksheets at once ~ please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on a project where I have approx 400 xls files that need to be
appended together in a single access table. I can import the files 1 by 1,
but am seeking a way to import all of them at once. Can anyone help?
 
Assuming they are all in the same directory, you could use the Dir function
to loop through the directory and do your imports. You might also consider th
FileSearch object which is more complex, but also more flexible. You can
find detailed info on both of these in VBA Help.
 
Back
Top