?
Solved

Access 2007 Specification Export

Posted on 2011-03-02
9
Medium Priority
?
1,083 Views
Last Modified: 2013-11-27
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
Comment
Question by:Daren Anderson, MSIS
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 3

Expert Comment

by:JAMcDo
ID: 35023538
Can you post the code?

J.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35023628
how did you create the specification  "NewCarrier Export" ?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35028057
...and did you spell it correctly?

"NewCarrier Export"
"New Carrier Export"
"New Carrier"
"NewCarrier"
...etc
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 

Author Comment

by:Daren Anderson, MSIS
ID: 35047842
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35047962
my question is HOW did you create the specification  "NewCarrierExport" ?
0
 

Author Comment

by:Daren Anderson, MSIS
ID: 35048003
I created it thru the wizard and saved the export steps.....
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35048272
try this

docmd.runcommand acCmdSavedExports "NewCarrierExport"

0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 35048352
try this one too

docmd.RunSavedImportExport("NewCarrierExport")
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35104958
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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question