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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
Excell Otpions in office environment 0
Embed the same Excel multiple times 0
Bugs in Office 2019 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Many sheets, one DB? 1
External cell reference between two excel worksheets both in One Drive 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0

Top