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?
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?