AcFormat in Docmd

Could someone please help.
I am trying to export a table to a csv file using the following:

DoCmd.OutputTo acOutputTable, "shippedmanifest", acFormatCSV, "c:\scansystem\export\Shipped-" & Format$(StDate, "dd-mm-yyyy-hh-mm") & " " & Me.shippername & ".csv", False, "", , acExportDelim

acformatCSV isnt accepted.

Thanks in advance
Who is Participating?
If you like docmd.Outputto use acFormatTXT
I can recommend you to use for export as csv
docmd.transfertext with acExportDelim
iainmacleodAuthor Commented:
Perfect, many thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.