asked on Expport CSV From MS Access
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
My command
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?
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
My command
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?
Microsoft Access
Last Comment
Rey Obrero (Capricorn1)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.