Getting a query into a CSV file

[thalam]

Hi there,

I'm trying to store the results of a query into a CSV file. This query will only have one field present. I know I'm able to export it into Excel and from there on save it as a CSV file, but I'm hoping to have a command button so that when the user presses it, it will automatically make it a CSV file.

Is it possible? Any suggestions?

Thank You

 

[namliam]

Yes possible... Use the Docmd.Transfertext command and you will have to make an export specifiacation.

 

[thalam]

Thank you very much for pointing me into the right direction. I actually created a macro which simply shoots the information out into a CSV file.

Thanks again

Thevaker

 

[mjseim]

I'm looking to do exactly what you all are talking about... export directly to a CSV file. Would you please post some of your results for reference?

 

[namliam]

Wow that is draging up an old one You really tried... thats worth an answer....

Go to Macro (one of the tabs in the database screen) create a macro and make it export to your liking....
Or in coding (not macro but rael code) use the docmd.transfertext command. Read about how to use it in the access help, much better than me trying to explain it.

Hope it helps....