Changing an existing Export Specification in MS Access

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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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!!!

Discuss This Question: 1  Reply

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
    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 !!
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: