Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Torn between Kent & Essex, England
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export Specifications (AC 2K)

    I'm trying to export a table as a text file using:

    DoCmd.TransferText acExportDelim, tblout2_expspec, "tblOut2", strOutFileName, False

    tblOut2_ExpSpec has the follwing, er... specs:
    Delimiter - tab
    text qualifier - {none}
    tblOut2 has one field (fldConcatOut)
    The problem is that the file output by code has double quotes (") around each line - this file is to be picked up and processed by a robot, and it will get upset at the quote marks
    eg

    "A;Microplate, landscape4;;4;17;;4"
    "D;Microplate, landscape4;;4;1;;"
    "W;"
    "A;Microplate, landscape4;;4;57;;4"
    "D;Microplate, landscape4;;4;2;;"
    "W;"
    "A;Microplate, landscape4;;4;66;;4"
    "D;Microplate, landscape4;;4;3;;"
    "W;"

    whereas if i do it manually using the same export specs...

    A;Microplate, landscape4;;4;17;;4
    D;Microplate, landscape4;;4;1;;
    W;
    A;Microplate, landscape4;;4;57;;4
    D;Microplate, landscape4;;4;2;;
    W;
    A;Microplate, landscape4;;4;66;;4
    D;Microplate, landscape4;;4;3;;
    W;

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    Gavin

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Export Specifications (AC 2K)

    The only possibility that comes to mind is that the export specification didn't save correctly. The result you are getting looks very much like what you would get with the default settings for exporting text. Another option would be to fool the system and change the type to FixedWidth - that works as long as you only have a single field being exported.
    Wendell

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Export Specifications (AC 2K)

    I had no problem exporting your sample data as text file w/o quote text qualifiers using TransferText method. As Wendell suggests I'd double-check the export specs. I've noticed that sometimes when you first create export spec some of the settings do not seem to "stick". I'd do manual export & make sure delimiter & text qualifier settings have been saved properly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •