Trying to export Text file as Comma Delimited

[Buddha1]

Hello,
I am trying to export a query as a text file which I have been able to do, however I am trying to export it as a comma delimited file and I can't find that option under the Macro. It lists text, excel, html, rich text and so on. Can someone help me with this????

 

[mgolla]

How are you firing off the macro? Are you using a command button?

I would use vba to do the export and set up an export specification to create a comma delimited file.

To setup an export specification:

1) File -> Export
2) Change Save As Type to ->Text Files
3) When export dialog appears click on Advanced
4) Click on Save As
5) Enter the name for the spec

After creation of Export Specification:

Add code to a command button on click

DoCmd.TransferText acExportDelim, YourSpecName, YourQueryName,YourFileName

HTH
Mike

 

[Buddha1]

When I try to set up a specification I get an error box that states "Too few parameters expected"