How to access Excel as a database using UFT
Whenever we access excel through UFT, we always use the createobject method which blocks the excel and starts excel.exe process. It can result in problems if the test script stops abruptly. To resolve this issue you can access the excel as a database through UFT. Below code will help you with that. Dim oConn, oRS, arrData, x,iStart CONST adOpenStatic = 3 CONST adLockOptimistic = 3 CONST adCmdText = "&H0001" Set oConn = CreateObject("ADODB.Connection") Set objRecSet= CreateObject("ADODB.RecordSet") 'Open Connection oConn.Open "Provid...