Results 1 to 3 of 3

Paradox (*.db) Database Connection

This is a discussion on Paradox (*.db) Database Connection within the Excel Questions forums, part of the Question Forums category; Hello, I am trying to connect to, read data from, and edit a Paradox Database from within excel. I am ...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    11

    Default Paradox (*.db) Database Connection

    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:

    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]

  2. #2
    Board Regular
    Join Date
    Feb 2003
    Location
    Luton, England.
    Posts
    8,115

    Default Re: Paradox (*.db) Database Connection

    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.
    Regards
    BrianB (using XL2003 & 2010)
    Most problems occur from starting at the wrong place.
    Use a cup of coffee to speed up all Windows processes.
    It is easy until you know how.
    **FORMATTED/COMMENTED CODE IS MORE LIKELY TO GET A REPLY

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    11

    Default Re: Paradox (*.db) Database Connection

    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.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com