Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import(insert) data from an excel sheet to
Database(table).
- 2 Answers
- 7518 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 |
What is T_Exit and T_return?
what is mean by release in quality center and who will perfom?
what load_dll in winrunner
When do you use verify, Debug and Update modes?
what is virtual object?
How do you invoke a text file from winrunner?
How to break infinite loop?
i this is priya speaking, any 1 tell me project detail for NETBANKING and HELTHCARE pls send to this E-MAIL ADDRESS; (priyadharshni2@yahoo.com)pls qik, thank u once agajn.
which is the latest version in Winrunner
what is the automation frame work ?
Which Key is pressed to toggle between Analog and Context Sensitive Mode?
Explain the purpose of loading winrunner add-ins?
WinRunner 
