Import multiple excel worksheets at once ~ please help

J

jdrubins75

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?
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re-title multiple MS Project .mpp files at once 0
Embed the same Excel multiple times 0
Access 2003 and excel 0
Cannot import CSV file into ACCESS 1
Problem Importing Specific Worksheet From Workbook 6
Excel - Wich Function should I use? 1
Importing different worksheets from multiple Excel files 1
Access 2007 Import Issue/error 0

Top