what is the script(qtp) to export and import the datas from
MSaccess to Excel sheet.if anybody know plz tell me.

Answers were Sorted based on User's Feedback



what is the script(qtp) to export and import the datas from MSaccess to Excel sheet.if anybody kno..

Answer / e.g.g

hi, I'm you may export the access's datas into the QTP
datatable first,import it into the excel second.
haha,this maybe a foolish method -_-||

Is This Answer Correct ?    3 Yes 1 No

what is the script(qtp) to export and import the datas from MSaccess to Excel sheet.if anybody kno..

Answer / king

Set a=createobject("adodb.connection")
Set b=createobject("adodb.recordset")
a.provider="microsoft.jet.oledb.4.0"
a.open "E:\raju\login.mdb"
b.open "select * from login",a
i=1
Do while not b.eof
If not dialog("Login").Exist(2) Then
invokeapplication "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"
End If
dialog("Login").WinEdit("Agent Name:").Set b("User
name")
wait(1)
dialog("Login").WinEdit("Password:").Set b
("password")
dialog("Login").WinButton("OK").Click
datatable.SetCurrentRow(i)
datatable(1,1)=b("User Name")
datatable(2,1)=b("password")
wait(1)
If dialog("Login").Dialog("Flight
Reservations").Exist(1) Then
dialog("Login").Dialog("Flight
Reservations").WinButton("OK").Click
datatable(3,1)="Fail"
dialog("Login").WinButton("Cancel").Click
else
datatable(3,1)="Pass"
Window("Flight Reservation").Close
End If
i=i+1
b.movenext
Loop
datatable.ExportSheet "E:\raju\db.xls",1


i think this is working properly

Is This Answer Correct ?    2 Yes 1 No

what is the script(qtp) to export and import the datas from MSaccess to Excel sheet.if anybody kno..

Answer / devb

If you want to fetch data from access database and write into excel, the easiest way is to write VBA code. In macro directly connect to access database, fetch data into recordset and using range.copyfromrecordset save the data into excel sheet. No need to involve QTP.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QTP Interview Questions

I am trying to write a descriptive program for clicking on a perticular link.For that i wanted an index or location of that object.But when I viewing through spy, There was no index property of that object.What to do for getting index value.How can I get index? please any one let me know.

5 Answers  


Please explain the role of Regular expression in QTP

0 Answers  


How do you capture tooltip using QTP?

0 Answers  


what is test data

4 Answers   Wipro,


HI, pls help me on this, iam not able to capture getcelldata value in javatable... msgbox javawindow("").javatable("").getcelldata(3,3) but it diaplays empty...

0 Answers  


Explain about the test fusion report of quicktest professional (qtp)?

0 Answers  


How we can add actions in the test using QTP?

2 Answers  


What is the process for creating an automated test script using QTP assuming you have reviewed the manual test case and understand the requirements?

1 Answers   Infosys,


Tell me about your project? please help me how to tell about insurance project

0 Answers   Cap Gemini,


What r steps to migrate from Manual testing to QTP?(IN BOTH WEB BASED AND WINDOWS APP)

1 Answers   Wipro,


in which situation u will use recording and in which situation u will used to write script manually

1 Answers  


How to import the Test Results in QTP to an Excel sheet

4 Answers   Sonata,


Categories