VBA Code to Import Paradox Table into Access

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.
Who is Participating?
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.