Dropped record on automated transfer text

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

Guest

The automated import spec should not have the "has field names" option set to
True, this should be set to False.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Specs Changed "Magically" in Midst of Loading Sequence 3
Error Importing Fixed-Width Text File 1
import csv conversion & import spec error 1
Text import column order changes 7
Text on Multiple Rows of Text File 1
DoCmd.TransferText doesn't work unless you run a file manually 1
Problem Importing Fixed Length Text File Using VBA 1
Transfer Text. 3

Top