Paradox (*.db) Database Connection

[lukec]

Hello,
I am trying to connect to, read data from, and edit a Paradox Database from within excel. I am very green and a little confused on how to initiate the connection. Here is what I got:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim ConnectionString As String

ConnectionString = "OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;" _
    & "Data Source=C:\Program Files\ACI32\Databases\ACI Research\property.db;"
cn.Open ConnectionString

I get an error on the last line. I am assuming my connection string is wrong, but I am not sure. Any help? Greatly appreciated.

~Luke Campbell[/code]

 

[BrianB]

In the absence of other replies :-
1. I have not used the ADODB method, so cannot respond to this, except a simple web search shows you need to include something like :-
MyObj= CreateObject("ADODB.Connection")

2. I have always used ODBC. I suggest you record a macro using Data/Get External Data from Excel to get code. Check via Control Panel 'ODBC Data Sources' that you have the Paradox driver installed (a standard content of the MS Office setup disk).

This should enable you to read data. I have no experience of your more interactive requirements eg. writing data.

 

[lukec]

Thanks for the reply. I actually never got it to work. Instead I created an linked access database to the paradox database. In theory, I could than connect to the access database from excel. However, I have just decideded to write the macro in Access. Just seems to ultimately make more sense.

The idea of importing it with the external data tool is interesting. Unfortuantely I will eventually have to add records to the paradox database, so I don't think this will work. (I did end up using a similar feature in acess to import text files into databases for analysis.) Thanks for taking a shot.

~Luke Campbell

EDIT: Ok, should have read your post more carefully. That idea sounds good. However, I would like to distribute this macro to others once I finish it. I think it would be easier if I don't have to describe how to set up the database connection in the control panel. I think I will try it myself though, out of curiousity.