Use FoxPro 3.0 Tables In VB 6

[DineshDhiman]

Hi

I want to fetch data from FoxPro 3.0 table based on criteria such as where Name="Dinesh Dhiman" and show it in textbox placed on vB form.

I've connected VB and FoxPro 3.0 in following manner...

'connect FoxPro
    str = "Driver={Microsoft FoxPro VFP Driver (*.dbf)};SourceDB=d:\FPINV;SourceType=DBF;Exclusive=No;" & _
    "Persist Security Info=False;BackgroundFetch=Yes;Collate=Machine;"
 
    If cn1.State = adStateClosed Then connect_fox
    'If rsex.State = adStateClosed Then rsex.Open "exchdtl", cn1, adOpenDynamic, adLockOptimistic, adCmdTable
    If rsex.State = adStateClosed Then rsex.Open "exchdtl", cn1, adOpenDynamic, adLockOptimistic, adCmdTable

Is there anybody who can help me.
Please let me know any other better way to connect and fetch data from FoxPro 3.0 tables.

I'm using VB6. Its very urgent.

Regards,
Dinesh

[Hack]

Welcome to the forums.

This sounds like a simple SQL SELECT query.

Have you experience with SQL?