Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import(insert) data from an excel sheet to
Database(table).
- 2 Answers
- 7706 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 |
i would like to know the steps to write tsl exception and object exception with a simple example
what is the file extension for object in AUT captured by WR
HOW TO TEST A SOFTWARE/APPLICATION?
Can anyone explain me abt Winrunner Automation framework in detail and what r the steps involved in it
which function executes multiple TSL script
How many recording modes are provided by WR?
How do you configure gui map?
how to invoke the window based application in win runner
How do you analyze results and report the defects?
Can we run WinRunner scripts on the backend?
what is the basic knowledge required to work in BFSI domain ?
7 Answers HCL, Nucleus Software, Standard Chartered,
How to to get the information from the status bar without doing any activity/click on the hyperlink?
WinRunner 
