Data Type Conversion Error on Import

[Seti]

I am trying to import a text file, fixed width (419 bytes), and I get the above error. This is due to Access dropping a byte or two of data after every 4096 rows. This causes all of the data to shift one byte to the left on row 4097 for example, and produces invalid dates. 01311998 becomes 13 11 998_. Is this a known bug? Is there a work around?

Currently I am resorting to opening my text file in a text editor, cutting 60,000 rows at a time into Excel, and then linking Access to Excel. Based on the size of the files and the number of files, I would rather just go directly into Access.

Any ideas? Thanks.

Seti

 

[Seti]

Well, I found out what the problem was. When the text file was created, the line end character was a single new line character and Access needs both the carriage return and new line character when importing text files. When I added the additional character to each line, the problem disappeared. Thanks to all who pondered this.

Seti