Import Multiple Excel Sheets into Access 2000

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.
 
J

Joe Fallon

Check out DoCmd.TransferSpreadsheet and try running it 8 times in a row in
code and use a different Sheet name for each run.
 
Top