Outputting results of a query in .csv format

M

Mandy

I need to output data from the result of a query in csv format, to enable download into a DOS application. At the moment I am outputting in Excel format and then converting to .csv, surely Access 2000 can accomodate this, does anyone know how?
 
A

Allen Browne

Try the TransferText action/method.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mandy said:
I need to output data from the result of a query in csv format, to enable
Click to expand...
download into a DOS application. At the moment I am outputting in Excel
format and then converting to .csv, surely Access 2000 can accomodate this,
does anyone know how?
 

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

Adding data to MS Access from csv file 0
Programmatically Change Double Data Type To Long Integer 8
Excel And Notepad 3
Can I output to a file.csv 3
CSV->Excel Data Problem 1
open UTF8 CSV 0
Exporting CSV File in format "FilenameYYYYMMDD" 7
Excel does not accept text format! 0

Top