I am working on upgrading an old VB 6 app running with a paradox db to VB.NET running on MS SQL. What I need is an automated way to extract the data from the paradox in .NET, and insert it into MS SQL.

I downloaded the ODBC driver for paradox and queried a table. It works fine. The thing is this table has two blob fields in it and .NET doesn't even recgonize them (meaning this table with 7 fields only shows 5).

Any idea on how to do a binary read or something to get these blobs out??

I'm not sure of that, but i remember that the only good ODBC drivers for paradox tables were those from MERANT, and they were not available for download, you should pay for them.

Just an insight...