Link to home
Start Free TrialLog in
Avatar of MickaelE
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?
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

No, You can't open Paradox Database Files in SQL Server.
Instead open your (*.db) database file in Paradox and then Import records into SQL Server if required..
ASKER CERTIFIED SOLUTION
Avatar of PJBX
PJBX
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Well I know that my post works. ID:26129607