Dropped record on automated transfer text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a spec to import a text file. When manually imported this works
fine. However, using VB script (DoCmd.TransferText) it imports with all
appearances seems fine except that it invariably always drops the first
record. (Obviously this is an issue). It's a fixed width file with only about
5 fields, the automation is set up as fixed. Why would it drop the first
record in automation, the rest of the file is fine, but manually using the
same spec there is no issue?
 
The automated import spec should not have the "has field names" option set to
True, this should be set to False.
 
Back
Top