importing an entire excel workbook into access

[Guest]

How do I import a multi-sheet Excel workbook into my table in access? I have
set up a macro to do it, but it's not importing the whole workbook, just one
(or a few?) of the sheets. The data in the the woekbook is one big data set,
same fields but more rows that Excel allows - will be about 250,000 records
in all.
Thanks!

 

[Guest]

I assume you are using the TransferSpreadsheet method. It will only import
one sheet. Unless otherwise specified in the range argrument of
TransferSpreadsheet, it is going to import the first sheet.

Using Macros, this will be a little tedious. You will need a
TransferSpreadsheet for each worksheet in the workbook. Define the table you
want to import to and it will add the rows from each import to that table.