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
iainmacleodAsked:
Who is Participating?
 
als315Commented:
If you like docmd.Outputto use acFormatTXT
I can recommend you to use for export as csv
docmd.transfertext with acExportDelim
0
 
iainmacleodAuthor Commented:
Perfect, many thanks
0
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.