Export to CSV?

[jus_doc]

I am currently running a macro that pulls information from a Qry and exporting it to a .xls document

But, I need to be able to export it to a .csv. below is a sample of the output data opened in note pad

Site ID,Account Number,Last Name,First Name,PIN,
05555,123456,LastName,FirstName,12345655555,

 

[GohDiamond]

Have you viewed this one?
http://www.access-programmers.co.uk/forums/showthread.php?t=236893

Cheers!
Goh