Sending 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

 

[dk99]

I have managed to export the file, however I am unable to sent the file from access ? Any ideas ?

 

[easyit]

what do you mean with send? If you can export, than you have the file you want I would say?

 

[dk99]

The problem is that I want to automate the database so that by the user clicking a button it would sent a csv to a distribution list. At present I use the SendObject function but this truncates the fields that are longer than 256 characters ?

Any help would be appreciated.

 

[mp9]

You could try the acFormatTxt option for the format parameter of your DoCmd.SendObject statement.

 

[dk99]

Thanks, but this sends it as a text file. Any other ideas ?

 

[easyit]

Send it as an attachment?