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.
doyle007Asked:
Who is Participating?
 
harfangCommented:
Not much experience with Paradox, but...

Manually:
* 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?
(°v°)
0
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.