What does 'subscript out of range' mean when linking a table in Ac

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003 and trying to link an excel table. I keep getting
the message 'subscript out of range'. I can't figure out what's wrong.
Any ideas?
 
I was having same problem trying to import from Excel. I posted a request
for help but did not get any responses. In the meantime, I deleted all empty
columns and rows (they were empty cells I deleted, but the worksheet
previously had content in cells out to last column of the worksheet). I then
had no problem importing the worksheet into Access. I think that once cells
in the worksheet have content, even if later deleted, Excel (or Access) looks
at those cells as part of the import. Deleting the empty columns and/or rows
restores them to a "pristine" condition (I'm guessing). Hope this helps.
 

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

subscript out of range 7
What does it mean when it say subscript out of range 8
Subscript out of range messge while importing from Excel to append 8
Subscript out of range 2
Subscript Out Of Range Importing XLSX 1
Exporting from Excel 2007 5
What does subscript out of range mean? 26
ACCESS 2007, "subscript out of range" what's it mean; how to corre 9

Back
Top