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

Help with importing from excel

P: n/a
Need help when importing excel sheet with cca 8.000 records in a new table I
get message subscript out of range. why?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Mihael" <mi***@migra.hr> wrote in message news:<ck**********@ls219.htnet.hr>...
Need help when importing excel sheet with cca 8.000 records in a new table I
get message subscript out of range. why?


Don't know. Prolly Access assuming incorrect things about the data in
the SS. Try creating an explicit import spec and using it with
TransferSpreadsheet. If that doesn't work, take two aspirin and call
me in the morning.
Nov 13 '05 #2

P: n/a
I think you can't use import specifications with spreadsheet imports.
Import Specification is to be used with text import only.

I've found out that you have the most control over how you import files with
text import. You have next to no control with spreadsheet import.
Therefore, I think you had better export the spreadsheet within Excel to
text such as tab-delimited file and then import the text file using an
import specification to Access.

Herbert

"Pieter Linden" <pi********@hotmail.com> bl
news:bf*************************@posting.google.co m g...
"Mihael" <mi***@migra.hr> wrote in message

news:<ck**********@ls219.htnet.hr>...
Need help when importing excel sheet with cca 8.000 records in a new table I get message subscript out of range. why?


Don't know. Prolly Access assuming incorrect things about the data in
the SS. Try creating an explicit import spec and using it with
TransferSpreadsheet. If that doesn't work, take two aspirin and call
me in the morning.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.