cfcProgrammer
Programmer
Hi I am trying to create a statement using data from excel cells...
Here is the statement I am trying to create... all of it is text except for the info I am requesting be replaced by the data in the cells.
I have 1000 of these to run so once I get this statement created I will then copy down the column for all 1000 records
"Insert into nms_mobile_id_event (SERIAL_NUM, IMSI, BILLABLE_MOBILE_ID, EVENT_TYPE_CODE, SDATE, EDATE, USER_ID, EVENT_DT)
Values(=""'""&B2&""'"", ""'""&A2&""'"",""'""&C2&""'"", 'TS', TO_DATE('12/14/2009 11:13:46', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/3000 23:59:59', 'MM/DD/YYYY HH24:MI:SS'),'COLLEENC', sysdate);"
Please Help, I am not a proficient excel user!
Colleen
cfcProgrammer
Here is the statement I am trying to create... all of it is text except for the info I am requesting be replaced by the data in the cells.
I have 1000 of these to run so once I get this statement created I will then copy down the column for all 1000 records
"Insert into nms_mobile_id_event (SERIAL_NUM, IMSI, BILLABLE_MOBILE_ID, EVENT_TYPE_CODE, SDATE, EDATE, USER_ID, EVENT_DT)
Values(=""'""&B2&""'"", ""'""&A2&""'"",""'""&C2&""'"", 'TS', TO_DATE('12/14/2009 11:13:46', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/3000 23:59:59', 'MM/DD/YYYY HH24:MI:SS'),'COLLEENC', sysdate);"
Please Help, I am not a proficient excel user!
Colleen
cfcProgrammer