Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Unanswered: Flat dile data load in db table


    I have a flat file where in i have data like

    A A1 A2 B B1 B2 C C1 C2 D D1 D2 ~ A A3 B B3 C C3 D D3 ~ A A4 A5 A6 B B4 B5 B6 C C4 C5 C6 D D4 D5 D6 ~ .... and so on

    Here A,B,C,D are my columns of a table and A1 A2 as two different rows. Also, B1 B2 are corresponding B column values. Also ~ specifies my end of each row/rows.

    Please help me loading this data in a table like

    A B C D
    A1 B1 C1 D1
    A2 B2 C2 D2

    Is there a way i can handle this programatically.

    Thanks in advance,

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Is there a way i can handle this programatically.
    Yes, write a program that does what you want it to do.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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