Importing Paradox 8 DB using DTS

[MrShhh]

Hi all,

Does anyone know how to import a Paradox 8 database into SQL Server 2000 using DTS? The trouble I have is there are Paradox data sources available in the connections dialog box, but only up to version 5.x. I figure I need Paradox 8 to appear in the list of data sources but I can't find anything out about how to achieve this.

Cheers

 

[johnherman]

Have you tried the Paradox 5 drivers? They might work. I have seen this happen with DB2 Unix versions, where the drivers at version 5 actually still work with DB2 v8.1

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[MrShhh]

Thanks for your advice John. I have tried the drivers for Paradox 5 but they don't work. I've thought of another way of getting around this, which is to save each table individually as a Paradox 5 table. I've tested this and it works, it even imports blob fields successfully. It is a little tedious as this can only be done table by table and there are 15 databases with 20 odd tables each. Maybe I'll find a way of saving all the tables as version 5 in one go.