Import multiple excel sheets to Access DB

[Astello]

I've been trying to load data from multiple excel worksheets in multiple workbooks into one table in Access. The first one loads fine, but after that I get errors and can't load anything else. All of the sheets are in the same format, so that shouldn't be the problem. Every solution I've tried has been a bust. All I want is to take all of my data and put it into one big database. Any suggestions?

 

[gemma-the-husky]

what commands are you using to load the data

code, or manual?

 

[Astello]

I've tried doing it manually one-at-a-time, but it didn't work.