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.

Does QTP run in any environment?

0 Answers  

---

Is it possible to test Flat file using QTP? I have two file- first file is Input file and second file is output file. Input file has Format like first 2 field is record type, next 10 field is Description. Output file also has format. I want to check this file format using QTP. Is it possible?? please reply with example.

2 Answers   Wipro,

---

what is TOM in qtp?

5 Answers   Accenture,

---

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

4 Answers   QQS, Satyam,

---

Can anyone help.i need total excelsheet operations,shortcuts in testing environment from starting onwards....

0 Answers  

---

h u call the function

6 Answers   Wipro,

---

What is the need and applications of learning VB script for a automation(QTP) engineer ain Realtime ?

1 Answers  

---

Hello everyone! I am just writing a small test for a windows application. I have a problem with a text output value. The value i am trying to catch is presented in a scrollable textbox. When the text is too long, only a portion of it gets captured. Do you have any experience with this?

0 Answers   HSBC, T Mobile,

---

There are 3 types of frame works in QTP 1. Linear frame work 2. Modular frame work 3. Key word driven frame work. Can any body explain the above 3 frame work models. y2k_ram2000@yahoo.com

6 Answers   Fidelity, GDS, IBM, TCS, Wipro,

---

write a script to verify the image path(src property) of the images which are in web pages.

0 Answers  

---

Hi guys can any plz help me how to send fax in sample Flight Appication

1 Answers  

---

1.IF SOME OBJECT IN APPLICATION IS NOT IDENTIFIED BY QTP? HOW WILL YOU OVERCOME THIS? 2. WHEN AND WHYDO U GO FOR DESCRIPTIVE PROGRAMMING? 3. WHAT IS THE DIFFERENCE BETWEEN VB AND VBA? 4.WHAT ARE THE REGULAR EXPRESSIONS YOU USED? 5.IF ANY REQUIREMENT IS ADDED IN YOUR PROJECT, HOW WILL YOU PROCEED TO DERIVE THE TEST CASES AND HOW WILL YOU PERFORM AUTOMATION FOR IT?

2 Answers   RBS,

---