I'm trying to figure out what type of database uses these specific .dat and .idx files. When I view the .dat files using a binary file reader I see Record Schema followed by somewhat decipherable data names. A little further down I see Key Schema whch apears to be a comma separated list of clear text referenc开发者_高级运维es.
Each .dat file has a matching .idx file. Each .dat file contains the phrase "Record Schema" and "Key Schema" as described above.
How would I convert these files so I can use them in an SQL database?
First search result returns it's an Informix database. Couldn't confirm it for you though.
Should be Dbase, you can probably also open those with FoxPro, from within FoxPro you can upsize
to SQL Server
From memory it sounds like Informix
or a tonque in cheek remark
Outlook Express
:)
If I remember correcttly they are Paradox files. If they are, you should be able to access them via ODBC.
These are FairCom’s c-tree Plus database file. And to read them in sql you need ODBC friver, below link explains it well. http://dynamicsconfessions.blogspot.com/2010/07/using-odbc-to-read-on-line-field.html
精彩评论