Converting into cvs format

[peljo]

I have a code for converting into a cvs format:

DoCmd.TransferText acExportDelim, "qryDocExportSpecification", "QryDocs", "QryDocs.csv"

However, the file i get at the end in MyDocuments is an excel file and not a word norepad file. Why is i so and how could i correct this situaion ?

 

[Guus2005]

It is a regular textfile however windows believes it is not. Rightclick the file and select "open with". Select the program you want the CSV to open in. Check the checkbox to make this permanent.