Inserting values in a particular cell

[adnan_rafiq]

Hi friends,

Just wanted to run past a query for the experts and pros. What if I want to put a value in a cell(2,1) and cell(2,2) of an xls or csv file. consider the attached csv. The cell(2,1) and cell(2,2) should be filled with words "Line Item" and "Driver" respectively.

[swuehl]

Not really sure how you want to proceed from that, but maybe like

LOAD

     If(recno()=2,'Line Item',@1) as @1,

     if(recno()=2,'Driver',@2) as @2,

     @3,

     @4,

     @5,

     @6,

     @7,

     @8,

     @9,

     @10

FROM

[Prep.csv]

(txt, codepage is 1252, no labels, delimiter is ',', msq);

[adnan_rafiq]

Ca this be done with load *?

[MarcoWedel]

please try to explain with your expected result and the script that your currently use.

thanks

regards

Marco