Excel Proble m

[#1]

I want to import data like below format ,first column should be displayed  and remaining should be below one ,no need to rename in the script  level ,how to import like ?

EXCEL :

LOAD [ ID] as MMM_ID,

'Bedford' as PLANT,

      @1,

     @6,

     @7,

     @8,

     @9,

     @10,

     @4,

     @5  

FROM

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

where [ ID] <>' ';

[#2]

My problem is solved ,Thanks for all

[#3]

Hi,

Good to know that your issue is resolved.

Can you please close this thread by making correct/helpful answers, so it is easier for others facing the similar issue to figure out the hints/answers.