Thread: How to access .KDB database?
03-06-07, 00:20 #1Registered User
- Join Date
- Mar 2007
Unanswered: How to access .KDB database?
Am new in here and also a noobie if you consider my database skills! I am decently acquainted with MySQL but absolutely ZILCH when it comes to any other database.
I have received a database application on a CD from a friend. The CD has a searchable database of companies in a particular state and my friend wants the data to be ported to his website.
I have searched through the directory structure of the CD and found a 126MB file with .kdb extension that I suspect holds all the data.
I need guidance on how to extract all the data and port it to mySQL.
Any help will be greatly appreciated.
Thanks a lot!
03-09-07, 10:39 #2Grand Poobah
- Join Date
- Sep 2003
The .kdb file is a rdbms from KxSystems ... As for porting it, you might check their site www.kx.com for a driver to use for connecting to the database ... Say an ODBC driver ... Then you'll need to write the scripts in either mysql or some other dbms to extract and then write to yuor mysql db ...Back to Access ... ADO is not the way to go for speed ...