How to Import(insert) data from an excel sheet to
Database(table).
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 does the function represents TL_EXIT and T_EXIT ?
2 Answers PowerNet Technologies,
plese tell me about vss?
My husband had stampped h1b visa and was valid for another 1year. problm is that he lost his pasport in travelling and we got new one in tatkal scheme. and so we applied for restamping and my dependent (h4)visa. As per immigration team petition will be the same only stamping has to b done.. what questions will they ask and what are the chances to get it aproved?? pl reply
hi,i am sudha.i am married.i had done my BE in 2005.i learnt testing tools.i dont no how to tell about my self.please send me good answer about that infomation i gave.
What is the default type of constant TSL supports?
Do we need start up file in win runner??if yes then why?and no then why?
tell me the detailed exaplanation of different types of tesiting
how do you rate your self in winrunner
What are the Win Runner tools for functional testing?
Hi guys pls any one help me , I am facing this problem since last one week , my question is in there 1000 rows and 1000 coloums , i want to pick the one record , how ?
In the Object properties MSW id,MSWclass will appear..what exactly MSW means..?
What are the advantages and disadvantages of Context sensitive and Analog Recording?