PDA

View Full Version : How to get data from .mdb database?

whoops.slo
25th January 2006, 17:16
Where can I get driver for Access database? Is there something else than ODBC?

TNX!

Luka
wysota
25th January 2006, 18:22
No. ODBC only. Unless you convert your access dbase to something more edible...
whoops.slo
26th January 2006, 18:15
TNX for confirming my fears...
I have found SQLite Analyser (http://www.kraslabs.com/sqlite_analyzer.htm) (evaluation for 30 days, but is good for a quick solution). There are several others open source, but none of them converted my databases like I want to.

Tnx again!
Luka
wysota
26th January 2006, 21:27
The easiest way to do the conversion would be to write some kind of script in Access which will transform the contents of the database into a set of INSERT statements which you can then execute from within some normal dbms to fill it with your data (remember to generate the CREATE TABLE entries too).