Subscript out of range error

G

Guest

When I import an Excel Comma Seperated Value Windows file into Microsoft
Access I am getting the error Subscript out of range. What could be causing
this error?

Thank you in advance
 
A

Alex White MCDBA MCSE

It is what it says, something is trying to reference something out of range,
common things that cause this error are arrays that have a length of say 11
elements and you are trying to access the 12th entry of course it does not
exist. It could be that your importer (what ever that is!!!) is expecting a
field on a specific line and it is not there.

Can you be more specific about your error, is it code you have written or a
macro, can you post the code so we can see what is going on.
 
G

Guest

Alex,

Could it be due to one of the cells in the Excel spreadsheet that I am
trying to import that has more than 255 characters? I am thinking this may be
the issue since the text fields in a Microsoft Access database can only
handle 255 characters.

Thank you,
Kip Sanborn
 

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

Access Subscript out of range when importing into access 2010 from excel 0
SUBSCRIPT OUT OF RANGE 3
What causes "Subscript out of range" during Access import? 2
Importing Excel data into Access table 4
import data from Excel - "subscript out of range" 6
Subscript error message 1
Subscript out of Range 1
LDBUser_GetUsers error: subscript out of range 6

Top