Pasting an old code used by me.
set DB_Connection=CreateObject("ADODB.Connection")
DB_Connection.Open "Provider=MSDASQL;DBQ="&FileName&";FIL=excel
8.0;MaxBufferSize=4096;Driver={Driver do Microsoft
Excel(*.xls)};ReadOnly=0;"
DISFileName=""&FilePath & "SCV_Discrepancy_"&orgname&"_"&tctype(0)&".xls"
xlsheetName=oldsheet
DISSQLQuery="select * from ["&xlsheetName&"$] where DELTA >=1 "
On Sun, Jun 27, 2010 at 12:30 AM, dcr <[email protected]> wrote:
> Hi to All
>
> I need Vb script function, Reg In QTP through EXCEL file using ADO
> object and
> connection string and using the SQL QUery like
> select * from [sheet no$] where row ='condition'
>
>
> Kindly send the function.
>
> Thanks in advance.
>
>
> Regards,
> Byzoor,
>
> --
> You received this message because you are subscribed to the Google
> "QTP - HP Quick Test Professional - Automated Software Testing"
> group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]<mercuryqtp%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en
--
Regards,
Ganesh Muralidharan
'God Never Forgets'
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
