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!
I was getting the same error for a while too. It was very annoying.
It came down to my column names and making sure the columns were formatted for the correct data in Excel before importing it into Access. Once I made sure the column names were identical (including copying and pasting the formatting from/in Excel), I didn't get the name errors. And once I made sure the formatting (date, text, yes/no boxes) was correct, the "Subscript out of Range" error disappeared and I was able to save the import process so I don't have to do it all over again if the source file gets updated.
Had the same thing. Did Save As and chose older version Excel and that file imported fine!