TransferText First Line Omitted

  • Thread starter Thread starter accessmanager
  • Start date Start date
A

accessmanager

Guest
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.
 
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....
 

Users who are viewing this thread

Back
Top Bottom