How to Import(insert) data from an excel sheet to
Database(table).
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 information is contained in the checklist file?
What is a checkpoint and what are different types of checkpoints?
How do you handle dynamically changing area of the window in the bitmap checkpoints?
What is debug mode in Winrunner?
what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance
by useing qtp where the maximum people feeling difficult
Difference between winrunner and test director?
Hiiiiiiiii This is lavanya.....At present i m working as a MATLAB developer at CMC(A tata enterprise)from about1 year .now i want to move to testing field as a fresher?Is this possible...can anyone give me a suggestion regarding d testing field.....
Without the gui map, use the phy desc directly?
How to force wr to learn the sub-items on a menu?
Explain the purpose of different record methods?
What is the disadvantage of loading the GUI maps through start up scripts?
What is the use of test director testing tool?
you hae a inbox and got a mail how can you know it is there or not write script.
Which are default codes winrunner generates when we start the application?