Export in CSV format with DoCmd.OutputTo

[djmc]

I would like to know how I can export to CSV format using the DoCmd.OutputTo function in VBA. I know how to do it in .xls format but not .csv.

As well I know that when a file name is not specified in the arguments, a window will popup asking you where you would like the file to be saved in. How would I do this along with having a predefined filename in the filename box in the window when the user chooses which directory to save it in.

Thanks.

 

[PHV]

Take a look at 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 FAQ222-2244

 

[djmc]

I did the following:

DoCmd.TransferText acExportDelim, , strName, strExportName, True

but it won't prompt me for where I want the file to be saved (since i specified a filename). Is there a way to get the window to pop up along with my default file name shown in the window?

 

[PHV]

Depending of your version of office you may consider playing with the FileDialog object before the export.

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