Answer Posted / manas

Dim Conn, rs, ListOfRecords, x
' Connect to the Microsoft Access Database by createing a
object
set conn=CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/DataBase1.mdb" ' ex: Name of DataBase is
DataBase1.mdb

' Retriving data from Access using the SQL Query
' Column_name1 - Suppose first column
' Table - Suppose Name of Table
set rs=CreateObject("ADODB.recordset")
rs.Open "Select Column_name1 from Table", conn

for each x in rs.Fields
ListOfRecords = ListOfRecords & x.Column_Name1 & vbCrLf
next

MsgBox ListOfRecords

can i compare two databases using QTP ?

2393

---

How can I open a EXCEL file from QTP Resultviewer with reporter.ReportEvent function call. Example: Test files for details click "here". And clicking "Here" in the resultviewer will open a local EXCEL FILE.

2295

---

Explain the difference between call to action and copy action?

992

---

how to find that tools work well with your existing system?

1867

---

what is keyword driven testing in qtp?n how is it useful?

1927

---

What are the different types of recovery operation?

1023

---

Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...

1960

---

What is parameter in qtp?

1085

---

is there any addin for remedy user application

2273

---

What are the advantages of a Hybrid framework?

1141

---

Is QTP supports Unix. If yes, then how the test automation is done?

2188

---

How to find a window is minimized or not

1884

---

Hi All, How to Compare two strings character by character in QTP

1504

---

Hoe can we do retesting using functions please give the code for it using login page

1945

---

What are some test assets and related extensions of qtp?

1034

---