How to import multiple Excel files to Access?

[zhenboy]

Is there a way to import multiple Excel files to an Access database?

Im trying to write a macro to do that but I've never written anything like this before. What I want is to load/import all the Excel files from the target folder to a Access database. They should be on the same table after importing. Is there a way of doing this?

[DougMcDonald]

Wouldn't it be easier to paste all your excel spreadsheets into one main file, and then just import that?

That way you can get around the need to import more than one at a time.