Change Defaults on Export Text Wizard 1

[RaisinGirl]

Hi:

I want to set up a macro that will export the data in several tables in pipe-delimited format with no text qualifiers. Problem is, Microsoft uses the Export Text Wizard Default setings, which are comma-delimited with "" text qualifiers.

Can anyone tell me how to change the defualt settings or anothe way to tackle this problem?

Thanks.

 

[RickSpr]

Export it once using the Export Text wizard. Just before hitting the "Finish" button, click the "Advanced" button. This gives you a window where you can save "Import/Export Specs". Give your set of specs a meaningful name, and save.

In your TransferText macro step, enter the spec name in the Specification Name parameter. That's it! Rick Sprague