Exporting a table to CSV format 1

[techkenny1]

Hi all,

I have a requirement to be able to export a table to csv format.
I know I can use the Export command in the menu for this, but I would like to just be able to use a command button to do it automatically.
Many thanks,

kp

 

[dhookom]

Try the OutputTo method. Here is an example from Help

DoCmd.OutputTo acOutputTable, "Employees", _
    acFormatRTF, "Employee.rtf", True

Duane
Hook'D on Access
MS Access MVP