[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • Last Modified:

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.
0
doyle007
Asked:
doyle007
1 Solution
 
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now