Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import Paradox data to Access (Access 2000)

    I am trying to import data from a Paradox file (circa 1992) to Access 2000. Any suggestions?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Import Paradox data to Access (Access 2000)

    Can you export the paradox data to a txt file (comma delimited or fixed width), if so then this should be a breeze to Access to import from the txt file.
    If this doesn't work, I'm at odds here, although I would have a look at the contents of the file using something like UltraEdit to try to determine if it could be imported by VBA code.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Paradox data to Access (Access 2000)

    I really appreciate this information. You have helped me to stop pulling out my hair! I will try this and get back to you.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Import Paradox data to Access (Access 2000)

    I believe if you install all of the optional stuff with Access 2000 you will be able to import Paradox tables directly into Access - at least I get that option with 2002. As far as I know the table formats in Paradox didn't change much from 1992 to the present. That way you wouldn't have to figure out how to export to text from Paradox.
    Wendell

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Import Paradox data to Access (Access 2000)

    As an addition to Wendell's reply: Access 2000 supports importing from Paradox versions 3, 4 and 5 - this should be OK for a file from 1992. See MSKB article ACC2000: The File Formats That Are Supported by Access 2000 When You Import, Export, and Link for more information.

  6. #6
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Paradox data to Access (Access 2000)

    Thank you very much.

Posting Permissions

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