Importing from Excel - error message: "subscript out of range"

[chris bridgeman]

Trying to import data from Excel into an existing table in Access 2007. The import fails and keeps getting the error message: "subscript out of range". All of the column headings in the 1st row are exactly the same as the table in Access, and the data types are all text except for the key which is a number. I've imported to this table many times and not had a problem and can't figure this out. Any suggestions?

[June7]

We need something to analyse. What method are you using for import? Post relevant code. Provide the Excel file for analysis - follow instructions at bottom of my post.

[chris bridgeman]

We need something to analyse. What method are you using for import? Post relevant code. Provide the Excel file for analysis - follow instructions at bottom of my post.

I've solved the problem by converting the Excel files to .csv files and then importing the .csv file. Still not sure why the Excel file won't import directly, but I appreciate the help. I can't forward the file I'm importing to for your analysis because it is way too large even when compressed.

[June7]

Could have provided a reduced dataset. However, since you have a solution, guess that is moot.