DoCmd.TransferText acImportDelim, "spec1", "filetmp","filename",false

Discussion in 'Microsoft Access External Data' started by Satya, Jul 17, 2004.

  1. Satya

    Satya Guest

    I am going thru an Access based tool which imports data from text delimited
    file to Table.
    It has following code.

    DoCmd.TransferText acImportDelim, "Action_ImpSpec", "v_actionTmp"

    Access Syntax:
    DoCmd.TransferText ([TransferType], [SpecificationName], [TableName],
    [FileName], [HasFieldNames], [HTMLTableName], [CodePage])

    Now, I want to modifiy specificationname. How do I do that?
    How should I add a new specification file?

    --
    Satya
     
    Satya, Jul 17, 2004
    #1
    1. Advertisements

  2. Satya

    Satya Guest

    I found them.

    They can be accessed as given below.

    Method 1:
    Import Table --> "Text file" --> Delimited Text option --> Advanced -->
    Specs

    Method 2:
    Tools --> Options --> Select "Hidden Objects", "System Objects"

    Specs are stored in system tables, "MSysIMEXSpecs" and their columns in
    MSysIMEXColumns

    --
    Satya



    "Satya" <> wrote in message
    news:%...
    > I am going thru an Access based tool which imports data from text

    delimited
    > file to Table.
    > It has following code.
    >
    > DoCmd.TransferText acImportDelim, "Action_ImpSpec", "v_actionTmp"
    >
    > Access Syntax:
    > DoCmd.TransferText ([TransferType], [SpecificationName], [TableName],
    > [FileName], [HasFieldNames], [HTMLTableName], [CodePage])
    >
    > Now, I want to modifiy specificationname. How do I do that?
    > How should I add a new specification file?
    >
    > --
    > Satya
    >
    >
     
    Satya, Jul 17, 2004
    #2
    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. HSalim

    docmd.transferText to Memo Fields

    HSalim, Sep 26, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    350
    HSalim
    Sep 26, 2003
  2. Guest

    Access 97 Upgrade 2000 Error In "DoCmd.TransferText acExportFixed"

    Guest, Nov 20, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    1,962
    david epsom dot com dot au
    Nov 21, 2003
  3. Ken Wilkinson

    DoCmd.TransferText acImportDelim with Tab

    Ken Wilkinson, Apr 13, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    1,811
    Ken Wilkinson
    Apr 13, 2004
  4. Alan B. Densky

    TransferText acImportDelim Problem

    Alan B. Densky, Mar 17, 2007, in forum: Microsoft Access External Data
    Replies:
    5
    Views:
    2,076
  5. JR
    Replies:
    1
    Views:
    1,486
    Gina Whipp
    Apr 10, 2010
Loading...

Share This Page