Importing multiple Excel worksheets from same workbook

  • Thread starter Thread starter Brian
  • Start date Start date
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!!!
 
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
 
Back
Top