Friday, March 30, 2012

Import Paradox 8 DB into SQL Server 2000 using DTS

Hi,

I'm trying to import a Paradox 8 db into SQL Server 2000 using DTS but the list of data sources in the connections dialog only caters for version 5.x or older. Does anybody know how to get the data source for v8?

If not, is there any other quick and efficient way to import a paradox 8 db as I have to import around 15 of them to do.

ThanksHave you tried the highest version available to see if it works ?|||You can also purchase odbc software from datadirect:

link (http://www.datadirect-technologies.com/products/odbc/matrix/connectodbc.htm)|||Cheers for your help. I've tried the highest version, but it doesn't work. I've since discovered that you can save Paradox 8 tables as v5 and then import them. It's time consuming though as it appears you can only save them as v5 table by table, not the whole database as it would work with something like MS Access.|||No problem. Either spend the time (and money) to find a solution or purchase the driver - normally it is cheaper to purchase the driver, however, to convince those above you may be more difficult.

No comments:

Post a Comment