Export to CSV file

[debbieg]

I need to export data from a table to a CSV file. I have a form with a command button that runs the following:

Dim strSaveFileName As String
strSaveFileName = "C:\ADP\PCPW\ADPDATA\"
strSaveFileName = strSaveFileName & "EPIJJV01.csv"

DoCmd.TransferSpreadsheet acExport, , "tblADP", strSaveFileName, True

I get the following error:

3027
Cannot update. Database or object is read-only.

Why am I getting an error about updating when I'm trying to export data?

Thanks,
Debbie

 

[debbieg]

Never mind ... I used this and it works fine.

DoCmd.OutputTo acOutputTable, "tblADP", acFormatXLS, strSaveFileName, False

Sorry to waste your space.

Thanks,
Debbie