TransferText Error with Export spec

Discussion in 'Microsoft Access External Data' started by PaulP, Oct 26, 2009.

  1. PaulP

    PaulP Guest

    I'm using Access 2007 with Windows XP. When I specify the Export Spec within
    the code I get an error "The text file spec 'Create-Pallet-Labels' does not
    exist." I can run the code without the spec. I see the spec in the list of
    saved exports.

    Do I need some type of qualification so that the spec can be found within
    the form?
    The code is assigned to a button on a form.

    Code:
    Private Sub Pallet_Label_Button_Click()
    On Error GoTo Err_Pallet_Label_Button_Click

    DoCmd.TransferText acExportDelim, "Create-Pallet-Labels",
    "Pallet-Label-Extract", _
    "C:\Pallet-Labels.CSV", False

    Exit_Pallet_Label_Button_Click:
    Exit Sub

    Err_Pallet_Label_Button_Click:
    MsgBox Err.Description
    Resume Exit_Pallet_Label_Button_Click

    End Sub
     
    PaulP, Oct 26, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Beth

    Import /Export Spec Location

    Beth, Sep 24, 2003, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    742
    Joe Fallon
    Oct 4, 2003
  2. JumboShrimps

    Import spec is "Empty" in TransferText command?

    JumboShrimps, Feb 5, 2004, in forum: Microsoft Access External Data
    Replies:
    4
    Views:
    935
    Nikos Yannacopoulos
    Feb 9, 2004
  3. Guest

    EXPORT SPEC - INCONSISTENT

    Guest, Mar 29, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    290
    Guest
    Mar 29, 2004
  4. Seljo

    Moving and Import/Export Spec

    Seljo, Apr 2, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    330
    Guest
    Apr 2, 2004
  5. Methuselah

    Changes to Export Spec not saved in Access 2000

    Methuselah, Jul 7, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    646
    Methuselah
    Jul 12, 2004
  6. Guest

    Export Spec - BCP

    Guest, Nov 16, 2005, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    324
    Guest
    Nov 16, 2005
  7. Chris Moore

    Error Saving Import/Export Spec

    Chris Moore, Sep 24, 2009, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    5,411
    Jeff Boyce
    Sep 25, 2009
  8. Bill Phillips

    Export Spec Problem

    Bill Phillips, Nov 23, 2009, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    914
    Douglas J. Steele
    Nov 23, 2009
Loading...