Export query as csv file instead of a text file

S

Square Eyes

Hi

I'm having problems exporting a query as a csv file. The application (Sage
accounts) i want to export it to can only import it if it has a .csv file
extension. As i can only save the query with a .txt file extension I need to
somehow convert it to a .csv file. Any suggestions much appreciated.
 
A

Alex White MCDBA MCSE

You can use the name function to rename the file.

after the export.

name "c:\exported.txt" as "c:\exported.csv"

I think sage can import with other extensions if you put *.txt in the
filename box.
 
S

Square Eyes

I renamed it as .csv, as suggested and Sage imported it no poroblem. Only
thing is that it reported some errors with my data, which I need to try fix
but that's a separate issue. Thanks, for the solution!
 
Top