How to Import(insert) data from an excel sheet to
Database(table).
- 2 Answers
- 6895 Views
- GE Capital, iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naga chiranjeevi kota
Session="mysession";
connstring="DSN=DQMCHIRU;UID=scott;pwd=tiger;server=Orcl";
rc=db_connect(Session,connstring);
dqmdata = "C:\TestSheet.xls";
rc = ddt_open(dqmdata, DDT_MODE_READWRITE);
ddt_get_row_count(dqmdata,noOfRows);
printf(noOfRows);
for(i=0;i<noOfRows;i++)
#for(i=0;i<1;i++)
{
a = ddt_val_by_row(dqmdata,i+1,"a");
b = ddt_val_by_row(dqmdata,i+1,"b");
c = ddt_val_by_row(dqmdata,i+1,"c");
d = ddt_val_by_row(dqmdata,i+1,"d");
x="insert into dqmchiru values('"&a &"','"&b &"','"&c
&"','"&d&"')";
printf("R"&i+1&": "&x);
dc=db_execute_query(Session,x,rows);
}
dc=db_execute_query(Session,"Commit",rows);
db_disconnect(Session);
ddt_save(dqmdata);
ddt_close(dqmdata);
answer by: Naga Chiranjeevi Kota(iGATE)
| Is This Answer Correct ? | 1 Yes | 3 No |
Have you ever created a start-up script?
which function executes multiple TSL script
Other than Regression testing where can also it can be used.
What does the function represents TL_EXIT and T_EXIT ?
2 Answers PowerNet Technologies,
What are the modes of script recording in winrunner ?
what is the gui map & gui map file in winrunner?
can any one provide some testing material?
What is the Purpose of Virtual Object Wizard in WinRunner?
When Both Developer and Test Engineer conducting testing different?
what is data driven framework?
how to insert check points? whatis the gui check point?
Is it possible to place a Logical name in a data table and can use that logical name in the script? Tell me with mentioning function names..?
WinRunner 
