Changing an existing Export Specification in MS Access
I have added 2 fields to a table that is being exported to a text file. The export is done via TransferText and uses an Export Specification.
I would like to know how to change the existing Export specification to add the two fields. I have tried various things in the File->Export wizard but nothing works. I keep getting a message that the export spec has less fields than the table, but it does not let me add the fields.
I realise that I can create a new spec but then i need to go through the old one to check and changes all the values (delim, formats, separators etc). Hence, was hoping to be able to just add the two fields and overwrite the existing spec with the same name.
Thanks for your help in advance.
Software/Hardware used:
Software/Hardware used:
ASKED:
July 15, 2005 3:39 PM
UPDATED:
July 18, 2005 7:41 PM
RELATED QUESTIONS
- How to remove specific lines from a text files using either vbs or bat.
- Using combo box to populate a sub form which is used to create a new record
- Can you show lotus notes table rows as rows in a view?
- Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?
- Excel 2007 'Edit Links' Command deleting information
Answer Wiki:
The easiest way to do this is to do a manual export of the new file using the export wizard. Click on advanced options and click save as to name the export specification to the same name as the old specification. Access will promt you if you wish to overwrite existing spec of the same name. say yes!!!
To see all answers submitted to the Answer Wiki: View Answer History.
Thanks for your response MaryPat.
Saving an export spec of the new file with the same name, is effectively the same as creating a new spec. What happens is that the settings for the export spec are set to the default/current settings and not the settings of the original spec. For example, if you saved the original spec with delimiter ‘TAB’ and text qualifier ‘”‘
and you now save with the same name, but your current default is delimiter comma and qualifier ”’ then you will overwrite the spec with these values!
I was hoping to change the existing spec so that these values do not have to be a concern and one does not have to first note down the original values, and then re-enter them on the new (same named) spec (which BTW, is what I did and everything is working fine). It’s just a minor inconvenience, but I was just curious, especially since Import Specifications can be changed !!