Thread: Excel and Dbase
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeremy Lowe Jeremy Lowe is offline
external usenet poster
 
Posts: 2
Default 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