Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1076
  • Last Modified:

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.
0
Daren Anderson, MSIS
Asked:
Daren Anderson, MSIS
  • 4
  • 2
  • 2
  • +1
1 Solution
 
JAMcDoCommented:
Can you post the code?

J.
0
 
Rey Obrero (Capricorn1)Commented:
how did you create the specification  "NewCarrier Export" ?
0
 
Jeffrey CoachmanCommented:
...and did you spell it correctly?

"NewCarrier Export"
"New Carrier Export"
"New Carrier"
"NewCarrier"
...etc
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
Daren Anderson, MSISAuthor 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, MSISAuthor Commented:
I created it thru the wizard and saved the export steps.....
0
 
Rey Obrero (Capricorn1)Commented:
try this

docmd.runcommand acCmdSavedExports "NewCarrierExport"

0
 
Rey Obrero (Capricorn1)Commented:
try this one too

docmd.RunSavedImportExport("NewCarrierExport")
0
 
Jeffrey CoachmanCommented:
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now