Expport CSV From MS Access
Posted on 2014-01-09
A client has asked that I export a file in CSV format. Fro some reason I've always exported in spreadsheet format.
I'm looking at the TransferText command as the solution. It looks easy enough but I keep getting an error 3027, Cannot update. Database or object is read only.
My data is pulled together in a query called qrySSPropInfo
DoCmd.TransferText acExportDelim, , "qrySSPropInfo", wkFileLocandName
wkFileLocAnd Name is set above to C:\ExportSS\PropInfo"
I treid replacing the query name with a table name and go the same result.
What is the issue? If I get this to work will it export in CSV format?