By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,996 Members | 1,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,996 IT Pros & Developers. It's quick & easy.

Access 2007 "Subscript Out of Range"

P: 1
Hey all,
I am using Access 2007 and tried to import an excel file by using the Import Wizard. I completed all steps and received an error when I clicked "Finish"...

the error came back as "Subscript Out of Range"

I googled and lived the issue, but did not find any helpful information. Any suggestions out there

J -
Jun 15 '07 #1
Share this Question
Share on Google+
5 Replies


ADezii
Expert 5K+
P: 8,706
Hey all,
I am using Access 2007 and tried to import an excel file by using the Import Wizard. I completed all steps and received an error when I clicked "Finish"...

the error came back as "Subscript Out of Range"

I googled and lived the issue, but did not find any helpful information. Any suggestions out there

J -
Try importing it manually.
Jun 15 '07 #2

P: 1
Hey all,
I am using Access 2007 and tried to import an excel file by using the Import Wizard. I completed all steps and received an error when I clicked "Finish"...

the error came back as "Subscript Out of Range"

I googled and lived the issue, but did not find any helpful information. Any suggestions out there

J -
Hi there,

Select excel file to import, click next and you will get error. Now on the next screen just checkout the data and verify the columns. Here scroll left till end. There might be extra columns which is causing this problem.

If you are getting extra columns in the data grid, you can solve it.

Now open your excel file, delete all extra columns. save the file and try again to import it.
Hope, this will help you.
Jul 4 '07 #3

P: 1
I was able to avoid the error by saving the Spreadsheet in .csv format. Imported fine from there.
Apr 9 '08 #4

P: 1
Just open the spreadsheet, click in the top left to highlight entire spreadsheet, right click->format cells. Select General and click OK. the import should work now.

I've run into this many times, and each time it was because somebody formatted one of the columns to something that access didn't interpret correctly when importing.
Jul 14 '08 #5

P: 1
I had the same issue, and found that one of my columns in Excel was formatted for text, while the matching field in Access was Number/Percentage. Once I changed it in Excel I was able to import the table.
Sep 25 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.