Snappy2873
Programmer
Does anyone know if there is any current or soon to be future support for importing or linking Paradox 7, 8 or 9 tables into an Access 97 environment?
snappy
snappy
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import or Link Paradox tables into Access 97?
- Thread starter Snappy2873
- Start date
- Status
Snappy2873,
Well, given that Level 7 tables (the type you're talking about) have been around since ~1996 and MS has yet to update their ODBC drivers, you're not likely to see this added to freely-available tools.
Having said that, you have a few different alternatives:
1. Use Paradox itself (or another BDE-enabled product) to transfer your data. Recent versions of BDE let you open MDB files. Once you're opened them, you can use queries, Tools | Copy Table, or any number of techniques to transfer data from your Paradox .DB files into the .MDB.
This requires some very specific configuration, though. See for details, particularly the last paragraph.
2. Obtain a third-party ODBC driver from Intersolv. This will let you open your Paradox Level 7 tables from any ODBC enabled resource. Be aware that it's rather expensive and that Corel provides it with Paradox v9 and WPO 2002/Pro (which includes Paradox 10 and Paradox Runtime 10).
3. Use Paradox to convert the Paradox 7 tables to an intermediary format supported by your version of Access, e.g. dBASE or simple text files.
I know it seems like a lot of work, but unless MS suddenly changes its mind about enhancing older versions of their software, it's about the only game in town. Sorry.
Hope this helps...
-- Lance
Well, given that Level 7 tables (the type you're talking about) have been around since ~1996 and MS has yet to update their ODBC drivers, you're not likely to see this added to freely-available tools.
Having said that, you have a few different alternatives:
1. Use Paradox itself (or another BDE-enabled product) to transfer your data. Recent versions of BDE let you open MDB files. Once you're opened them, you can use queries, Tools | Copy Table, or any number of techniques to transfer data from your Paradox .DB files into the .MDB.
This requires some very specific configuration, though. See for details, particularly the last paragraph.
2. Obtain a third-party ODBC driver from Intersolv. This will let you open your Paradox Level 7 tables from any ODBC enabled resource. Be aware that it's rather expensive and that Corel provides it with Paradox v9 and WPO 2002/Pro (which includes Paradox 10 and Paradox Runtime 10).
3. Use Paradox to convert the Paradox 7 tables to an intermediary format supported by your version of Access, e.g. dBASE or simple text files.
I know it seems like a lot of work, but unless MS suddenly changes its mind about enhancing older versions of their software, it's about the only game in town. Sorry.
Hope this helps...
-- Lance
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question