DoCmd.TransferText not getting all the date

  • Thread starter Thread starter Mike P
  • Start date Start date
M

Mike P

I am using the DoCmd.Transfter text to import data into a table. The data
being imported contains around 3000 rows. However, only 1200 are being
imported. There is not error given and everything seems to work fine.
Except when I manually check. I only have 1/2 the data. Any ideas here?
Below is the syntax I am using.

DoCmd.TransferText acImportDelim, "myClean_Import_Specification", _
"tblTmpPPrice", gstrImportFile
 
Mike,
the first thing to check is the text file. See if there is anything
different about the rows that do import OK and the rows that don't get
imported, especially the first row after the last row that imports OK. Look
for a missing delimiter, a line break inside a field or anything else that
is different.

If you are importing to an existing table, what happens if you allow nulls
and zero length strings in all fields? (unless you are doing that already)

Jeanette Cunningham
 
Back
Top