[mso] Re: Troubleshooting Access error- Access 2000
- From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 18 Dec 2006 20:12:07 +1100
According to an Office 2007 page
(http://office.microsoft.com/en-us/access/HA012322271033.aspx) this message
indicates that the import failed completely, not partially. I.e., even your
first row failed to import. This fits with my understanding too - normally
records failing to import will be placed into a separate table.
So, cut it right back to one of two rows and get them importing, then move
back to your 55,000 lines, then to your big file. Sounds like there is a
fundamental problem with your import. The page I referenced above includes
lots of good information that should be applicable to Access 2000.
Regards, Dave S
----- Original Message -----
From: "Robert Carneal" <carnealre@xxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Monday, December 18, 2006 8:16 AM
Subject: [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).
> //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
> *************************************************************
*************************************************************
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).
//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:
