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?

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. HSalim

    docmd.transferText to Memo Fields

    HSalim, Sep 26, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    646
    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:
    2,180
    david epsom dot com dot au
    Nov 21, 2003
  3. bomber
    Replies:
    1
    Views:
    694
    Guest
    Feb 25, 2004
  4. Ken Wilkinson

    DoCmd.TransferText acImportDelim with Tab

    Ken Wilkinson, Apr 13, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    2,264
    Ken Wilkinson
    Apr 13, 2004
  5. Gary Martens

    DoCmd.TransferText acExportDelim Error

    Gary Martens, Jul 13, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    7,292
    Guest
    Jul 23, 2004
  6. MVL

    doCmd.TransferText parameters

    MVL, Aug 6, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    784
    John Nurick
    Aug 6, 2004
  7. Alan B. Densky

    TransferText acImportDelim Problem

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