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 -_-||

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

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.

What is User defined function in QTP

6 Answers   Bank Of America,

---

can any one tell me what is process metrics and what is product metrics if possible give me example. Thank You

2 Answers  

---

If I want to run more than one test (With different functionality) with in one script, then what i do? plz. explain with any example.

4 Answers  

---

How To Export The Screen Shoots Along With The Test Reports In QTP Version 10? Thanks In Advance SenthilKumar

1 Answers  

---

Explain the concept of object repository & how QTP recognises objects?

1 Answers  

---

hi i have one doubt i have 4 yrs exp in testing and iam working one mnc in north but i have completed my degree correspodene is the companies are accept in south side some people are tellig they won't agree but i need correct answer plz let me know which companies are taking and not taking thanks in advance

8 Answers  

---

i am a begnner so am learning Error handling :tried using Recovery manager didnt work i want to be able to handle errors , e.g. if while running the test the folwoing does not show up then how can i use the If then else and goto next step in the test, as in many scenarios it does not show up Browser("The Shopping Channel -").Page("The Shopping Channel -_8").Image("easy pay").Click

0 Answers   Rogers,

---

What is throw object?

1 Answers  

---

How to record right click of a context menu and click on the selection ?

3 Answers  

---

What is the difference between gettoproperty and settoproperty?Explain with an example?

4 Answers   QQS, Satyam,

---

any challange that faced in your project? (please give me some examples in your project?

1 Answers  

---

How to test the login page in different ways in automation testing and i need code?

0 Answers   Cognizant,

---