Excel and Dbase

  • Thread starter Thread starter Jeremy Lowe
  • Start date Start date
J

Jeremy Lowe

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
 
Back
Top