Importing multiple Excel worksheets from same workbook

B

Brian

I work for a school district, and I am trying to import multiple worksheets
into Access as individual tables. Thus far, when I try to import the entire
work book, and go through the spreadsheet wizard, some of the worksheets have
no data. Is there an easier way to do this?

Please help!!!
 
J

Jeanette Cunningham

Brian,
if this is a once off project, it's probably easiest to check all the
worksheets in excel for no data. Put all the worksheets with no data at the
end of the workbook and note the name of the last worksheet with data.
Only import to the last worksheet with data.


Jeanette Cunningham
 

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

Importing different worksheets from multiple Excel files 1
Importing Multiple Excel Worksheets into An Access Table 4
Import Excel Workbook 1
Access Subscript out of range when importing into access 2010 from excel 0
importing multiple worksheets from a single workbook 2
Importing 10+ excel worksheets 7
Import Spreadsheet Wizard Subscript out of Range 0
Exporting Data to One Excel Workbook to Several Worksheets 2

Top