Read Each Worksheet in a file and load it to the table

[get4peterin]

Hi,

Is there a way in Access where I can read multiple worksheets in a spreadsheet and import it into the access database. Any kind of help or ideas is highly appreciated?

Thanks,

 

[John Big Booty]

The solution posted in this thread may be what you are after.