Import Spreadsheet Wizard Subscript out of Range

  • Thread starter Thread starter Will G
  • Start date Start date
W

Will G

I have a set about of about 100 goups of 3 data sets that I need to import
into three tables in Access 2007. Two of the data sets are Excel 2007
worksheets saved in a 2003 format. The third data set is an HTML page. I
can sucessfully import two Excel sheets and the HTML page from one set. When
I try to import another Excel spreadsheet after importing the HTML sheet I
get the 'Import Spreadsheet Wizard Subscript out of Range' error message. I
then have to quit Access and reopen the database. After reopening the
progarm, importing the Excel spreadsheets works perfectly. Just closing the
database does not solve the problem, I need to quit the porgram to be able to
import Excel after importing an HTML page.

If I don't import an HTML page I can import all the Excell sheets I want
without any errors. Also, I can import HTML page after HTML page without
error. I could just import all the Excel and then import all the HTML, but
becuase of how the data is generated, it is harder to keep things straight if
I do it this way. Also, it jsut bugs me when I get errors that should not be
errors.

Thanks for any suggestions.
 
Back
Top