View Full Version : TransferText First Line Omitted


accessmanager
12-03-2004, 05:08 AM
Using TransferText for importing a fixed width text file to a table by either Macro or Module the import consisently ignores the first line of data in the text file. I have checked that the correct parameters are set to recognise that there are no column headers in the text file. I do have a file specification set and this is working fine. I have also reordered the data in the text file to eliminate any data problems. If I insert a blank line at the beginning of the text file import is successful. However, I would not want to deploy this fix. Where next I ask.

yellow
12-12-2004, 02:56 AM
Try changing you import file to just have the first line in it. IE a one line file and see if it imports it with your import spec etc. If it doesn't import it, which it sounds like it won't, then I'd recommend taking another look at your spec or creating a new spec and seeing if that works....