Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import(insert) data from an excel sheet to
Database(table).
- 2 Answers
- 7638 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 |
soft key for virtual object wizard ?
What are the three modes of running the scripts?
If the data is stored in Excel sheet(2nd and 3rd), how to access it for Data Driven test; Ex: table = "c:\demo.xls" How to access 2nd or 3rd sheet data id demo.xls flie.
we have three windows with title(logical description),India.com,Government of India.com,India Inc.com.All three windows have similar properties and object.A test script has to be run on all these windows.what changes will u make in GUI or script so that the script runs succesfully on all these three windows with the least alteration required? Please explain clearly with steps.
what is the gui map & gui map file in winrunner?
why you are doing software testing, why testing necessary
Name the three modes of running the scripts?
what is the file extension for object in AUT captured by WR
How to convert Manual Test script into Automation Test Script?
In the Object properties MSW id,MSWclass will appear..what exactly MSW means..?
What is the process of file parsing in winrunner?
What information is contained in the checklist file and in which file expected results are stored?
WinRunner 
