This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have been importing Excel files for years. I recently upgraded to Access 2007 on a shared server (Windows Server 2003 R2, Service Pack 2) and now I can't import. Every time I get "Subscript out of Range" when I use the Import Wizard. The file is correct with the correct field names and data. I have tried importing into different tables and always get this error. I can try an .xls or an .xlsx file and neither work.
I have to paste the records in.
Help!
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Wildcard Characters) that might confuse Access?
This was my problem. I had Serial# and # a few other places!
And I love that the word cropped, but spelled with an "a", gets asterisked!
Wow.
I've had this problem intermittently for several years:
Spent hours ensuring columns in Excel were correctly formatted etc - and occasionally that was the problem, but often formatting made no difference - so I would come back to it a day later and then it would work... (This is now a duh moment! - why didn't I see the pattern?!)
So today the first import went fine, then when it **** out on the second, I closed and re-opened Accessand then it worked. No changes to the file, but now it would import.
Magic!
Thanks for the workaround - just saved me hours of frustration!
I have been importing Excel files for years. I recently upgraded to Access 2007 on a shared server (Windows Server 2003 R2, Service Pack 2) and now I can't import. Every time I get "Subscript out of Range" when I use the Import Wizard. The file is correct with the correct field names and data. I have tried importing into different tables and always get this error. I can try an .xls or an .xlsx file and neither work.
I have to paste the records in.
Help!
Sorry I'm a bit late. Just started using Access 2007 and had the same problem importing from Excel 2007. You probably have this figured out already. But for the benefit of others who landed in this site while searching, read on...
I had 14 columns in my table. My first import of about 120,000 rows went without incident. My second import attempt of about 10,000 rows resulted in "Subscript out of range". I noticed that the import wizard sample showed a field named F15 that shouldn't be there. There were only 14 fields (up to F14) in the excel file I was importing, and 14 fields in the table of 120,000 rows from the first import. All I could see in column 15 of the excel sheet was white space. Apparently, someone had deleted information that was there before but for some reason was still being detected by the import wizard. What I did was to select the next ten or so columns in the excel sheet, starting from column 15, clicked on delete entire column, and presto! No more subscript out of range. There are probably other causes and solutions to this problem but this is one of them. I hope this works for you.
I had same issue this morning. Did a manual Compact/Repair and issue resolved.