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!