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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment