Export query as csv file instead of a text file

G

Guest

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.
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top