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.

How do you data drive an external spreadsheet?

1 Answers  

---

Write a QTP script to print all the link names displayed in a web page

4 Answers   TCS, Virtusa,

---

What is the main disadvantage of using low level and Analog modes?

2 Answers  

---

1.how can we report the QTP test result in a different excel sheet 2.

3 Answers   Aurigo,

---

How to make Non reusable actions into reusable action? is that feature available in QTP

2 Answers   Ordain Solutions,

---

What is QTP testing process?

0 Answers  

---

How can we open an Excel sheet through the script

8 Answers   eSymbiosis,

---

Limitations in QTP?

0 Answers   CIL,

---

What is the difference between two actions?

1 Answers   Wipro,

---

There are some links on the web page,write a script to count and click those links and check the text on the page displayed on clicking the links.

3 Answers   Tech Mahindra,

---

hi i have one issue while selecting weblist i want show one particalur item in weblist .ex one weblist they are monday to sunday i want show the reporter like thurday in particular weblist can you help me about this thanks balaji

5 Answers  

---

suppose i can done the project in automation tool with QTP in that time what i can say?

3 Answers  

---