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 (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).