Send a query as CSV

[dk99]

Is there a way to send a query as a csv automatically.

I have tried within a macro, but the only options are text or excel.

Unforunately excel truncates the fields (as some contain more than 256 characters) and the text looks wrong and cannot be easily read.

Alternatively is there a way I can export a query with fields that contain more than 256 characters (other then text format) ?

 

[PHV]

Have you tried the DoCmd.TransferText method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886