I have created a macro that is ran on a schedule and exports a query as a 

delimited text file. The text file is created as a comma delimited file 

and I would like to change it to Pipe delimited (or something else). From 

searching around on the web I get the impression this can definately be 

done but can not find any specifics on how. So, how do I set the delimited 

options when exporting something using code?



Right now I am using a macro that calls a function which uses the 

TransferText command. Is it an option in that command or is there 

something else I should use?

You can do this with an output specification (the second setting on the

TransferText macro action).  To create one, export the table manually, and

click the Advanced button on the wizard dialog box, and then 'Save As'.



HTH,



-Roy



-----Original Message-----

From: brose@u... [mailto:brose@u...]

Sent: Thursday, August 23, 2001 7:50 AM

To: Access

Subject: [access] Changing Delimited Options When Exporting Through a

Macro





I have created a macro that is ran on a schedule and exports a query as a 

delimited text file. The text file is created as a comma delimited file 

and I would like to change it to Pipe delimited (or something else). From 

searching around on the web I get the impression this can definately be 

done but can not find any specifics on how. So, how do I set the delimited 

options when exporting something using code?



Right now I am using a macro that calls a function which uses the 

TransferText command. Is it an option in that command or is there 

something else I should use?