Access 2007 Specification Export

I created a specification in Access 2007 to export information from a query to a comma delimited file (.csv) and I was trying to use the switchboard to create a command to run code to run the export.  However when I try to run it - I get "The text file specification "NewCarrier Export" does not exist.  You cannot import, export, or link using the specification.  What am I doing wrong?

Thanks.
Daren Anderson, MSISPresidentAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this one too

docmd.RunSavedImportExport("NewCarrierExport")
0
 
JAMcDoCommented:
Can you post the code?

J.
0
 
Rey Obrero (Capricorn1)Commented:
how did you create the specification  "NewCarrier Export" ?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jeffrey CoachmanMIS LiasonCommented:
...and did you spell it correctly?

"NewCarrier Export"
"New Carrier Export"
"New Carrier"
"NewCarrier"
...etc
0
 
Daren Anderson, MSISPresidentAuthor Commented:
Sorry was out on a customer install - here is the code and yes, I did try to recreate the export as well - as you can see by my commented out code...

Function CarrierExport()
On Error GoTo CarrierExport_Err

'Perform Export functionC
'DoCmd.TransferText acExportDelim, "New Carrier Factor Exports", "qryExportLeads", "C:\Documents and Settings\Owner\My Documents\CarrierFactor\Exports.csv"
DoCmd.TransferText acExportDelim, "NewCarrierExport", "qryExportLeads", "C:\Exports.csv"

CarrierExport_Exit:
    Exit Function

CarrierExport_Err:
    MsgBox Error$
    Resume CarrierExport_Exit

End Function

0
 
Rey Obrero (Capricorn1)Commented:
my question is HOW did you create the specification  "NewCarrierExport" ?
0
 
Daren Anderson, MSISPresidentAuthor Commented:
I created it thru the wizard and saved the export steps.....
0
 
Rey Obrero (Capricorn1)Commented:
try this

docmd.runcommand acCmdSavedExports "NewCarrierExport"

0
 
Jeffrey CoachmanMIS LiasonCommented:
Saved the Export "Steps" or Export "Specs'?

Be sure in the wizard you saved the "Export Specification"
And make certain, you are spelling it correctly
untitled1.JPG
0
All Courses

From novice to tech pro — start learning today.