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