Results 1 to 7 of 7
  1. #1
    Join Date
    May 2005
    Posts
    119

    Red face Unanswered: Exporting Data/1st three lines NOT CSV..

    I have a specific format that I need to export data to. The first three lines of the document MUST be in the form of:

    ascii
    ,
    klg, Eastern Daylight Time,1,1

    PineGrove,0,2005/10/01,00:00,1,1.75,192
    PineGrove,0,2005/10/01,00:05,1,1.75,192
    Pinegrove,0,2005/10/01,00:10,1,1.75,192

    If I set this up in DTS and do an export, it puts commas after ascii - which I cannot have.

    I've also tried using two data sources and exporting twice (hoping to append), however, one just overwrites the other.

    Anyone have any ideas??

    Thanks in advance,
    Krista

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Is this from a table?

    Read the sticky at the top
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2005
    Posts
    161
    A couple of ideas...

    You can create two text files, one with the headers. Then use the dos copy command to make one file.

    copy file1+file2 file3

    Another option is to create a temporary staging table. It can have one large varchar column that contains the data. Then export from this table. This option requires a little work.

    Bill

  4. #4
    Join Date
    May 2005
    Posts
    119
    Quote Originally Posted by cascred
    A couple of ideas...

    You can create two text files, one with the headers. Then use the dos copy command to make one file.

    copy file1+file2 file3 [B][I]

    Bill
    YOU'RE AWESOME!! I WAS TRYING TO REMEMBER HOW TO DO THIS EARLIER TODAY!! THANKS SO MUCH!!!!!!!
    Last edited by Krista327; 10-03-05 at 16:01.

  5. #5
    Join Date
    Sep 2005
    Posts
    161
    You're welcome.

    Check your PM.

  6. #6
    Join Date
    May 2005
    Posts
    119
    What's PM?

  7. #7
    Join Date
    Sep 2005
    Posts
    161
    Private Message

Posting Permissions

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