Figured it out

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'paradox 5.x;database=C:\Trax\COM\private\scratch\', carriers)

Where the paradox 9 file is at this path C:\Trax\COM\private\scratch\carriers.db

NOTE: I always heard it was not safe to write using MS driver. No idea if its true.

Only Tested under SQL 2000.

Tim S

This below also worked

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'paradox 7.x;database=C:\Trax\COM\private\scratch\', carriers)

This linked and above post helped

http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-03/0044.html