Excel and Dbase

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO retrieval from close workbook-data type issue 2
Import Access data to text file rather than Excel 3
ADO - Access to Excel 5
Run Time Error 91! What am I missing? 2
Trying to write a query 1
Syntax Error Writing in MDB table 3
A Script to Create a Recordset and Import Data to a Spreadsheet 7
Question on SQL from XL to Access 2

Top