http://quicktesthp.blogspot.com

QTP VBScript new series + Interview Question Bank on QTP for enrichment of Knowledge in QTP

This Site has been brought to you by HP Certified Expert of QTP.

Exciting new articles for October:

1) QTP Tip:Deselect all Radio Buttons

2) HP QTP Crypt Object

3)Adding Hyperlinks in Excel Spreadsheet

Best of Luck Friends ! ! !

Expert QTP
expert.qtp@gmail.com

All Articles are Copyright Protected. These are Free for Reading & Personal Use. Reproduction in Any Form without the Permission is Illegal & Strictly Prohibited.

Copyright © 2009 ExpertQTP

Google Search

Friday, June 6, 2008

Connecting to MS Access through QTP

This code connects your QTP to MS Access. Pretty cool though..

Option Explicit
Dim con, rs

Set con=CreateObject("adodb.connection")
Set rs=CreateObject("adodb.recordset")

con.provider="microsoft.jet.oledb.4.0"
con.open "c:\db1.mdb"

rs.open "select * from emp", con

Do while rs.eof="False"
msgbox rs.fields("v1")
msgbox rs.fields("v2")
rs.movenext
Loop

No comments:

 
Copyright © 2009 ExpertQTP