Subscript Out of Range error when importing into Access 2007 from Excel.

Anonymous
2010-06-16T03:47:16+00:00

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!

Microsoft 365 and Office | Access | For home | Windows

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.

0 comments
Answer accepted by question author
Anonymous
2010-09-03T16:30:08+00:00
  1. Just on a whim here, do you column headings use any Reserved Words (or

Wildcard Characters) that might confuse Access?

This was my problem. I had Serial# and # a few other places!

Was this answer helpful?

300+ people found this answer helpful.
0 comments

50 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2012-11-13T10:04:33+00:00

    Dear all,

    I was experience the same issue, both from txt and Excel - file.

    The course to me issue was due to the fact that Access 2010 couldn't read the text / field delimiter.

    After I changed the the delimiter from asterix 124 to ; it all worked fine.

    http://www.asciitable.com/

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-03-17T13:21:41+00:00

    Here is what worked for me when everything appeared correct (and it was) but I was getting the Subscript Out of Range error message:

    I perform Compact & Repair (under File tab in Access 2007-2010) and afterwards my Excel import worked like a charm. 

    Good luck.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-07-30T20:54:18+00:00

    Remove all visual formatting ...

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-09-03T21:44:33+00:00

    I had the same error message.  I closed Access.  After reopening and attempting to import again I encountered no errors.

    Was this answer helpful?

    0 comments