Subscript out of Range (Access XP)

Topic

New Reply

Good Morning,

I am trying to import an Excel XP spreadsheet with 19 columns and 1326 Rows into a new Access Table. I keep getting a Subscript Out of Range Error message from the Import Spreadsheet Wizard. What could be the cause? TIA.

Reply | Quote

Replies

Is it being imported into an existing table or is it being created anew?

Is is possible to send your spreadsheet for us to look at?

Reply | Quote

Try this:
– Select all empty columns to the right of the data in the Excel worksheet, then delete them.
– Also select all empty rows below the data and delete them.
– Save the workbook.
– Try to import again.

Reply | Quote

Greetings and thanks for the quick response. I copied the 19 X 1326 cells with data to a new worksheet and the import worked as I had hoped. Thanks again.

Reply | Quote