INSERT


Posted by Naveen on August 14, 2001 8:17 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 14, 2001 3:06 PM

Use the concatenation operator, &, instead of
the CONCATENATE() function.