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


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?

Expport CSV From MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.