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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Beth

    Import /Export Spec Location

    Beth, Sep 24, 2003, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    431
    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:
    604
    Nikos Yannacopoulos
    Feb 9, 2004
  3. Guest

    EXPORT SPEC - INCONSISTENT

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

    Moving and Import/Export Spec

    Seljo, Apr 2, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    194
    Guest
    Apr 2, 2004
  5. Chris Moore

    Error Saving Import/Export Spec

    Chris Moore, Sep 24, 2009, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    3,412
    Jeff Boyce
    Sep 25, 2009
Loading...

Share This Page