Import Multiple Excel Sheets into Access 2000

  • Thread starter Thread starter Stever
  • Start date Start date
S

Stever

I have an Excel document that contains 8 sheets... one for
each division. I need to get all of the data into Access.
The wizard lets me import one, then crashes when I try to
import another sheet into the table.
 
Check out DoCmd.TransferSpreadsheet and try running it 8 times in a row in
code and use a different Sheet name for each run.
 
Back
Top