Export ACCESS to csv Specification

Can anyone help me with a method or trick to troubleshooting an export problem.

I am exporting data from a table to a CSV file.  It has been working fine up until today.  The only two things that I can remember changing was one field name in the SPECIFICATION, and I moved from ACCESS 2007 to 2013.

I have not changed any of the code that was working.  It is getting the  PATH from a table and I am assigning the file name.  
The error I am getting is as follows.

"THE MICROSOFT ACCESS DATABASE ENGINE COULD NOT FIND THE OBJECT "ACCESSINVOICEEXPORTFILE.CSV".  MAKE SURE THE OBJECT EXIST AND THAT YOU SEPLL ITS NAME AND THE PATH NAME CORRECTLY.  IF IT IS NOT A LOCAL OBJECT, CHECK YOUR NETWORK CONNECTION OR CONTACT THE SERVER ADMIN"

the way I understand SPECIFICATIONS is that you can't modify an EXPORT spec, only import SPECS.... then you just use the IMPORT spec for exporting.  Is that correct?

I would go back to 2007, but have already uninstalled it and can't find install CD.

Here is the code I'm using  
Private Sub Command6_Click()
On Error GoTo SumTingWong

Dim stExportQry As String
Dim stmsg1 As String
Dim stMsg2 As String
Dim stMsg3 As String
Dim stExportPath As String
Dim stExportArchivePath As String
Dim stExportFile As String

stExportPath = Nz(DLookup("[FieldValue]", "tblParameters", "[Fieldname] = 'ExportPath'"), "No Path")
stExportArchivePath = Nz(DLookup("[FieldValue]", "tblParameters", "[Fieldname] = 'ExportArchivePath'"), "No Path")

stExportFile = "AccessPOExportFile.csv"

stExportQry = "qryTEMP_POExportCombined"
Dim stRpt As String
stRpt = "rptCurrentPOExportList"
'DoCmd.OpenReport stRpt, acViewNormal


            Dim stPath As String
            Dim stFileName As String
            Dim stDay As String
            stDay = Day(Date) & Minute(Time)
            stFileName = "POExportList_" & stDay & ".pdf"
            stPath = DLookup("[FieldValue]", "tblparameters", "[FieldName] = 'ExportArchivePath'") & stFileName
            DoCmd.OutputTo acOutputReport, stRpt, acFormatPDF, stPath

Debug.Print stExportPath & stExportFile


DoCmd.TransferText acExportDelim, "POExportSpec", stExportQry, stExportPath & stExportFile, True

stmsg1 = MsgBox("The export file has been created, would you like to clear Batch Table in preperation for the next Batch?", vbYesNo, "You need to clear the data table")
If stmsg1 = 6 Then
DoCmd.Close
DoCmd.SetWarnings False
Dim stSQL As String
stSQL = "DELETE tblTEMP_POExportCombined.* FROM tblTEMP_POExportCombined"
DoCmd.RunSQL stSQL
DoCmd.SetWarnings True
stMsg2 = MsgBox("The export table has been cleared", vbOKOnly, "Done")
Else
stMsg2 = MsgBox("Since you chose not to clear the Export Table, your next export file will contain these PO's along with any other PO's selected to export", vbOKOnly, "OK")
End If



Exit Sub
SumTingWong:
DoCmd.Echo True
DoCmd.SetWarnings True
Dim stMsg As String
stMsg = MsgBox(Err.Description, vbOKOnly)

End Sub

Open in new window


>>>>>>>>>>>>After further testing........
it appears that even if there is a file in the export directory, Access deletes the file.  But still won't create a new one.
TechGuiseAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Try recreating the Export Spec in 2013.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TechGuiseAuthor Commented:
I've requested that this question be deleted for the following reason:

No responses
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.