Export From Access 2003 to CVS file format

[Heather]

I am trying to get this export to work. Every time I do the export I receive
an error that the database or object is read only.

Here is my code

outputfilename = strFolderName & "\HSA_Paid_Denied_Extract_" &
Trim(Format(Date, "yyyymmdd")) & ".cvs"

DoCmd.TransferText acExportDelim, "HSA Extract Export Specification", "q-070
HSA Extract", outputfilename, True

 

[pietlinden]

I am trying to get this export to work.  Every time I do the export I receive
an error that the database or object is read only.

Here is my code

outputfilename = strFolderName & "\HSA_Paid_Denied_Extract_" &
Trim(Format(Date, "yyyymmdd")) & ".cvs"

DoCmd.TransferText acExportDelim, "HSA Extract Export Specification", "q-070
HSA Extract", outputfilename, True

Is the table already open somewhere else? If so you will get that
error.

 

[Heather]

No I verified that prior to posting here. The table is actually just a query
that I was exporting in an excel format. In excel it works just fine. In
..cvs or .txt I get the error.

 

[Heather]

Never mind it was a typo. That is what I get for staring at this for to
long. Thanks everybody