Hi all,
I have created an import specification in order to import a text file to an Access table. I need to add three additional fields to the specification. I go to File | Get External Data | Import and then select the .txt file with the additional fields. I click on the advanced button to bring up my Import Specification and attempt to add the new fields to the bottom of the grid. Whenever I click on "save as", the new fields I add have disappeared from the bottom and are not included in the specification! This happens whether I save the spec with the old name, or as a new spec. Short of starting from scratch (there are 120 fields that have no column headers in the .txt file but need field names in the Access table), is there anything I can do? Thanks in advance for any help.
Kelly
I have created an import specification in order to import a text file to an Access table. I need to add three additional fields to the specification. I go to File | Get External Data | Import and then select the .txt file with the additional fields. I click on the advanced button to bring up my Import Specification and attempt to add the new fields to the bottom of the grid. Whenever I click on "save as", the new fields I add have disappeared from the bottom and are not included in the specification! This happens whether I save the spec with the old name, or as a new spec. Short of starting from scratch (there are 120 fields that have no column headers in the .txt file but need field names in the Access table), is there anything I can do? Thanks in advance for any help.
Kelly