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> ¦b¶l¥ó
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.