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

Excel worksheet to Access data table

P: 9

I have a very large spreadsheet that I am trying to import to an access database. One of the worksheets is 28 columns and 3500 rows. I'm importing it to a table titled tblFlyingJEStock. I'm attempting to use the import data wizard, and I get to the final screen, but it pulls up an error saying "subscript out of range". What does the error mean, and how do I fix it?

If there is any important info that has been left out, or a better way to import than by using the wizard, please let me know.

Thanks in advance,
Sep 4 '07 #1
Share this Question
Share on Google+
1 Reply

P: 47
I've generally found importing from Excel quite troublesome and the error messages can be quite misleading. I would try saving the spreadsheet as a text file (tab delimited is probably better than csv in case any fields already contain commas). Then use the wizard to import the text file.
Sep 5 '07 #2

Post your reply

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