Import Borland BDE data into Access via ODBC

[jdmartin74]

I have some data in what I believe is a Borland database using the BDE (Borland Database Engine). I have data files ending .DB, .PX, .XG0, XG1, etc. plus a few others

I would like to get this data in Access.

Does anyone know of any (ideally free) ODBC driver to do this or any other way?

Thanks

 

[Remou]

My version of Access (2000) will allow me to import or link Paradox files straight from File->Get External Data.

 

[jdmartin74]

I've tried that, and I get an error saying "Incorrect collating sequence".

 

[Remou]

Just the db, right? .PX, .XG0, XG1 are indexes.

 

[jdmartin74]

Yeh. Found solution!

Edit value 'CollatingSequence' in:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Paradox

from 'Ascii' to 'International'.

I also did the same in:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Paradox