Access Table import error "Parsed"

[Guest]

I am trying to link or import a txt file with over 4000 records. I get an
error around 1300 rows and then the rest of the data is not imported/linked.

 

[Douglas J. Steele]

What's the error? Pretty hard to suggest anything without knowing that!

 

[Guest]

Hello Douglas,

The Import Text Wizard states; "Not all of your data was successfully
imported. Error descriptions with associated row numbers of bad records can
be found in the MS table 'ST_ProdShip_ImportErrors'.

ImportErrors = (Error, Unparsable Record, Row 1392. I am able to view this
row in my text file and it appears to be fine???? Any help you can offer is
very appreciated. Thanks!

 

[Douglas J Steele]

So what is different about the record in row 1392? Are there fields longer
than other rows? Are there dates that aren't formatted properly in that row?
Are there missing fields?

Did you look in table ST_ProdShip_ImportErrors?

 

[Guest]

Hello Douglas,

Can I have your e-mail, so that I can send you the txt file for you to
review? There are errors so far on row 1392 and row 3679. Thanks!

 

[Douglas J Steele]

Sorry, no. That's not how newsgroups work.

Paste the relevant details from the txt file here: I can't imagine it'll be
that much text. (Note that I'm not saying to attach the text file to your
post: merely to copy-and-paste the relevant lines.)

 

[Guest]

Hello Douglas,

Below is the line 1392's text.

5/18/2005 33220A-ATO 20 MHz Function/Arbitrary Waveform
Generator 9E 1855533 SGS-541 Trade 1 Zhejiang Scientific Instruments &
Materials Import & Export Co Ltd 119055 CN $0.00 $0.00 $0.00 $0.00
0.00% INTERNAL 97 Tian Mu Shan Rd HANGZHOU 310007 R06 Company Register
Number:463532-M c/o EXEL Logistics (M) Sdn Bhd "88A Lintang Bayan Lepas 9,
Phase 4" BAYAN LEPAS 11900 Penang 254335 SGS-541 Trade
Generic "16,827,344" 2/7/2005 2005ZSIR0135SP


It does not look any differant than the above lines.

 

[Douglas J. Steele]

And what does it say in ST_ProdShip_ImportErrors?

One thought: Do any of the successful rows have ampersands in them?