SUBSCRIPT OUT OF RANGE

[Guest]

Im using the Import Text Wizard in Access 2003 to import a text file into a
table but at the end, when I click "finish", I get the error message
"subscript out of range", do you know why?

 

[Guest]

Hi Jacques,

Have you rebooted your PC recently?

You might try using the instructions in this KB article to replace your
existing wizard files:

http://support.microsoft.com/?id=303769

When you open the text file in Notepad or Wordpad, is there anything obvious
that looks out of place?


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

I reboot my PC every day.
I didn't replace any file in the KB article because I didn't get any of
these error messages.
Click at http://www.taxtipcalculator.com/ebay-craigslist/table.JPG to see
the structure of my destination table and the content of my text file.

 

[Guest]

Replacing the wizard files should be a fairly quick thing to do. Yes, I could
certainly tell that the error message was not included in the KB;
nevertheless, I think it is worth a try to start with fresh wizard files.

How large is this text file? Have you tried deleting say half of the rows
in this file to see if you can import part of the file? If you are willing
to send me a sanitized copy of your database (ie. any sensitive information
removed), along with a copy of the text file, I will take a look at it for
you. If interested, please compact your database and add it to a .zip file
first. My e-mail address is available at the bottom of the contributor's page
indicated below. Please do not post your e-mail address (or mine) to a
newsgroup reply. Doing so will only attract the unwanted attention of
spammers.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________