MickaelE
asked on
How to open Paradox 7.x Database files in Sql Server
Hi,
I want to open paradox database files (*.db) in sql server 2005 or 2008. The db files are in version paradox 7. Can anyone give me a solution to do that?
I want to open paradox database files (*.db) in sql server 2005 or 2008. The db files are in version paradox 7. Can anyone give me a solution to do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh, and with the linked server, most definitely can use the openquery() as if it were a table as per PJBX post...
You will also note from my link above that the Jet engine did work in that other thread, and while it works fine for paradox 5 tables, it can run into problems for paradox 7 - so take the time to test and check which is the best solution for you.
You will also note from my link above that the Jet engine did work in that other thread, and while it works fine for paradox 5 tables, it can run into problems for paradox 7 - so take the time to test and check which is the best solution for you.
Well I know that my post works. ID:26129607
Instead open your (*.db) database file in Paradox and then Import records into SQL Server if required..