Excel and Dbase
 

I have been asked to build an appliation with a DBase back end and
Excel front end.

I have built a mockup in access and I am now trying to convert it to
DBase.

Can one connect to DBase using ADO (later on I run queries) and what
is the equivalent line for Dbase

Cnct = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
ThisWorkbook.Path & "\SampleData.mdb;"
Set Connection = New ADODB.Connection
Connection.Open ConnectionString:=Cnct

Thank you in advance for your help

Jeremy

Excel and Dbase
 

Try this link:

http://www.able-consulting.com/MDAC/...DriverForDBASE

--

(Jeremy Lowe) wrote in message . com...
I have been asked to build an appliation with a DBase back end and
Excel front end.

I have built a mockup in access and I am now trying to convert it to
DBase.

Can one connect to DBase using ADO (later on I run queries) and what
is the equivalent line for Dbase

Cnct = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
ThisWorkbook.Path & "\SampleData.mdb;"
Set Connection = New ADODB.Connection
Connection.Open ConnectionString:=Cnct

Thank you in advance for your help

Jeremy

Excel and Dbase
 

Thanks for your help

Jerme



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!