Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import(insert) data from an excel sheet to
Database(table).
- 2 Answers
- 7493 Views
- GE Capital, iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between gui map and gui map files?
How to do text matching?
How do u check FONTS in Login Window?
How do you make the configuration and mappings permanent?
Which function to use to compare the application date with system date?
Explain the purpose of gui spy?
global sheet and external excel sheet how it will work
How do you select multiple objects during merging the files?
How to find the local host name using winrunner ?
What is test parameter
What is debug mode in Winrunner?
How do you execute your tests from windows run command?
What is boundary test?
What do you verify with the sync point for object/window bitmap and what command it generates, explain syntax?
What is the purpose of gui spy?
