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.