Hi Guys,

I've got a collection of paradox tables that I need to connect to SQL server 2000.  I've been using DTS (with paradox 5.x), but as soon as I try to import/access the Data I get the following error :

Error Source: Microsoft JET database Engine

Error Des : Table is not in the expected format

Contex: Error calling OpenRowset on the provider

Any idea how I can around this, I don't have Paradox, just the tables .

Thanks in advance

Dave

LSF Systems Developer

Hello,

we had the same problem, when we have been importing a customer's data from _1992_ from an old PDX application to a new SQL Server based web app. We ended up by using a very good and cheap (almost free) tool (http://www.scalabium.com/pdx/index.htm; Paradox Viewer) to do a dump to Access first ...

No problems encountered afterwards

Good luck,

Hendrik

HI

this seem to be working really well.(http://www.scalabium.com/pdx/index.htm;

Thanks

dave