INSERT


Posted by Naveen on August 13, 2001 11:26 AM

Hi,

Could anyone help me with this? I am trying to write an INSERT statement in Excel with about 28 fields. But, looks like an Excel cell does not take so many fields. It gives a message that the function is too long.

=CONCATENATE("INSERT into Proj (Proj_Nbr, Proj_Name, Brt_Prty_Req, Create_Date, Est_Start_Date, Req_Date, Proj_Descr, Proj_Just, Est_Cost, Brt_Rev_Date, Brt_Prty, Is_Prty, Own_Dep_Cost_Ctr, Own_Dep_Co_Code) VALUES (", A2,",'",B2,"','",C2,"','",D2,"','",E2,"','",F2,"','",G2,"','",H2,"',",I2,",'",J2,"',",K2,",",L2,",'",M2,"','",N2,"');").

It takes only upto "N". But, I need this upto "AB".

Any ideas how to do this?

Thanks,

Naveen



Posted by Mark W. on August 13, 2001 12:46 PM

Try using the concatenation operator, &.