I had to connect a Betrive database(old accounting system) to MSAccess2002
recently.
Betrive is non-relational so its not fun. You have to have a "schema file" I
think they call it, that gives you the record layout of the datafile you
want to access. If you don't have that from the vendor you are in for a
nasty experience.
Our vendor gave us an ODBC driver for our specific application that
contained the "schema information" that allowed access to make sense of the
datafile. I actually ended up moving the records to SQL Server.
The only other way is to parse the datafile in text mode .... not a pleasant
thing to do. There are tools out there to help with this but its pretty much
a hit and miss manual process.
Good luck.
Chris
