VBA Code to Import Paradox Table into Access

Posted on 2006-04-26
Last Modified: 2008-02-01
I need to import a number of Paradox tables into Access 2000. Does anyone have any sample code they are willing to show me so I can also Import Paradox tables into access 2000.
It would be good if the code doesn't rely on linking the tables first. Any help will be much appreciated.
Question by:doyle007
    1 Comment
    LVL 58

    Accepted Solution

    Not much experience with Paradox, but...

    * Choose "File / Get External Data / Import"
    * Files of type: Paradox (*.db)
    * follow through...

    From VB:
        DoCmd.TransferDatabase acImport, "Paradox 7.X", ... provide the rest.

    Note: make sure to place the cursor on TransferDatabase and press [F1].

    Does that help?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now