Importing Data From Excel

[king_bowzow]

I need to import data from several different worksheets within the same Excel workbook into an Access database. I can't figure out how to import more than one sheet at a time. All the sheets have the column headings. I can import the first sheet, but when I try to import the second sheet Access tells me there is an error. It doesn't tell me what the error is though, so I can't go about trying to fix it. If there is a way to do this, I would like to import all the sheets at once. Any ideas?

[dcrake]

The question is are all the different sheets going to different tables or the same table?

When you use the import wizard you can specifiy the worksheet you want to import. You may have to create a different import spec for each worksheet.

David