Convert 500 Excel worksheets to 500 Access Tables

[HMIExcel08]

Hi All,

My Excel workbook has exceeded its limit. I have about 500 worksheets under the same stupid workbook. I’d like to export all of them to Access, each Excel worksheet to each Access table.

When I open a blank database on Access and hit InsertāTableāImport Table, I realized I can only import one single worksheet from my Excel workbook, which is takes accumulated 8 hours non stop to finishing importing all worksheets.

Is there any way/VBA code to finish importing all Excel worksheet at once? Or at least a workable time frame?

Thanks for your advices!

[Mikeopolo]

Can you post a sample of one of the worksheets?

If not, tell us what each column represents and its format?

And what verson of Excel?

Rgds
Mike