Access table export to *.csv

[exRP12Nuke]

Hello,

I am trying to export a table to a specific spot on a server in *.csv format, and I am not having any luck with my VBA. Here is my line of VBA for the export routine.

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tblImportUsageReading", _
    "\\CASPERSVRFS\Data\EMS\Product Support\Contracts\Contract Billing Hours\AMT Usages\ImportUsageReading_" _
    & Format(Date, "yyyymmdd") & ".csv", True

Do I need a different Excel Type, where am I going wrong?

Thanks!

 

[PHV]

Use the DoCmd.TransferText acExportDelim, ... method instead.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[exRP12Nuke]

PHV, that worked perfectly! Thank you!