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

 

[KenReay]

Hi

Try export as Excel, but give the filename an extension of .csv

does that do it for you

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Buddha1]

I changed the ext to csv but when I open the file in note pad it isn't seperated by commas it appears to be seperated by tab..

 

[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