[mso] Troubleshooting Access error- Access 2000

Hello everyone. I am trying to import a smaller file this time- just 55,000
records.

Is there a way to get Access to reveal which record is causing a problem? I
am getting an error message after I attempt to import that simply says:
Invalid Argument.
[OK]


Clicking "OK" brings this message up under the "Import Text Wizard"
An error occurred trying to import the file 'C:\AllUSA8\File001.TXT' The
file was not imported/
[OK]

There probably is a record in the file it is not sure what to do with, too
many / few commas, or too many / few quotation marks, or some undesired
character.

I am wondering if there is a way to get the record number it had a problem
with, and I will check the original data from that.

Thank you.

Robert

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: