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

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?
 
G

Guest

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

Top