Solved

Access 2007 Specification Export

Posted on 2011-03-02
9
1,054 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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 500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft Access report help 4 37
GA Ribbon creator 9 60
Calculation in a Report 13 41
Tabbed form question 5 18
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

734 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