Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to Import(insert) data from an excel sheet to
Database(table).

Answers were Sorted based on User's Feedback



How to Import(insert) data from an excel sheet to Database(table)...

Answer / atif

csv =comma separater version

Is This Answer Correct ?    1 Yes 2 No

How to Import(insert) data from an excel sheet to Database(table)...

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

Post New Answer

More WinRunner Interview Questions

What does the function represents TL_EXIT and T_EXIT ?

2 Answers   PowerNet Technologies,


plese tell me about vss?

3 Answers  


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

1 Answers  


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.

8 Answers  


What is the default type of constant TSL supports?

1 Answers  


Do we need start up file in win runner??if yes then why?and no then why?

1 Answers  


tell me the detailed exaplanation of different types of tesiting

5 Answers   Satyam,


how do you rate your self in winrunner

2 Answers   Infosys,


What are the Win Runner tools for functional testing?

0 Answers  


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 ?

1 Answers  


In the Object properties MSW id,MSWclass will appear..what exactly MSW means..?

2 Answers  


What are the advantages and disadvantages of Context sensitive and Analog Recording?

2 Answers   Telelogic,


Categories