Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    4

    Unanswered: linking to a paradox databse

    Hey,

    I'm having a serious problem.
    I'm running a monitoring program on a PC, this program stores its data on the local hard disk (once in a minute). The data stored are .db and .px files (paradox files, but don't know which version). With MS Access I want to read these files, so I can export the data to .xls or whatever. So I need a link in Access to the Paradox files.

    Has anybody got a clue how I can manage this??

    Regards
    Ren้

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    files | get external data | link
    select your paradox source


    the main problem is going to be that Access may corrupt your Paradox table so it may be prudent to test with a copy of the paradox file

    alternativel set up a DSN (data source name) define the path to the paradox files and then read these in either to access or excel directly

  3. #3
    Join Date
    Feb 2005
    Posts
    4
    Thnx for your Reply.

    Indeed if I use get external data, I get a corrupt message.
    Can you give me detailed information how to set up such a DSN, or were I can get more information about this problem.

    Thanks in advance
    kind regards

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Control Panel->Administrative Tools->Data Sources(ODBC)-> User/File/System DSN ...

    This assumes Windows 2000 ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Feb 2005
    Posts
    4
    OKay found the ODBC, but what are the next steps, I also see the User file system DNS, please help me with this

Posting Permissions

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