concerting into cvs format

[peljo via AccessMonster.com]

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 notepad file. Why is i so and how could i correct this situaion ?

 

[Allen Browne]

Are you sure the file is an XLS spreadsheet?
Or is it just that CSV files default to opening in Excel?

If you open the file with Notepad, you may find it is a text file after all.

 

[Peter Gillett]

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 notepad file. Why is i so and how could i correct this situaion ?

If you force a load of the file to NotePad (open Notepad and 'Open' the
file) then you will see that it is a text file, double clicking on the file
will load it into Excel as it sets itself up to do that but there is
nothing in the file other than text.

Peter