Importing Excel workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a quicker way to create a new Access database from an Excel workbook
that contains 200 worksheets without copying each sheet individually
 
I suspect that you could create a procedure that stepped through all the
worksheets, if they were named/numbered in a consistent, predictable
fashion.

But before you consider this, be aware that the way that data gets organized
in spreadsheets is fairly unproductive if imported directly into Access
tables. Have you looked into how you will normalize your Excel data before
proceeding in Access (if this step is necessary)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top