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:
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]
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:
Code:
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]