Export From Access 2003 to CVS file format

  • Thread starter Thread starter Heather
  • Start date Start date
H

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
 
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
Click to expand...

Is the table already open somewhere else? If so you will get that
error.
 
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.
 
Never mind it was a typo. That is what I get for staring at this for to
long. Thanks everybody
 
Back
Top