Getting a Type Conversion Failure when importing a large number of records into an access table every 2048 rows
Posted on 2009-04-13
I am successfully importing approximately 15,000 records from a text file into Access using the Get external data wizard. However, even though my text file has no errors, every 2048 rows beginning on row 2049, I am getting the Type Conversion Failure in several fields of the table for that row. It seems to be using the first character from the 2049th row for something in the 2048th record because the data in the 2049th row is off by one character which seems to be causing the error. This problem repeats itself again at rows 4097, 6145, 8193, 10241, 12289 and again in 14337. I assume there is some issue surrounding a bug in the software and a limitation around 2048 records. Can anyone help me with setting a buffer in Access or something that will solve this problem?