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.
 
Back
Top