Thread: Excel and Dbase
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
  
Posts: 459
Default 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
Reply With QuoteReply With Quote