Open/Import Access mdb files with Kexi

[Aldrik]

I installed KOffice 1.5 to test if I could convert some mdb databases to mysql with Kexi. When I open/import the mdb file it says "No appropriate migration driver found". I guess I need keximdb (they not in the package?)?

So I grabbed the source and when I do ./configure I get the following...

 + The KexiDB headers were not found
 + The KexiDB libraries were not found
   Required KexiDB development files were not found.
   If these are installed, you can use the --with-kexidb-includes
   and --with-kexidb-libraries configure options.
   If not, these may be available as a package for your
   distribution, or you can install them by installing Kexi
   from source

I'll look about more tomorrow and see if I can find out where to get the headers/libraries but if anyone knows it'll be a big help thx!

[askrieger]

Re: Open/Import Access mdb files with Kexi

Synaptic to the rescue (maybe). I started synaptic, searched on kexi and found the following packages: kexi, kexi-mysql-driver, kexi-postgresql-driver, and libkexi-dev. As well as some irrelevant things. There's no mdb driver, but the libkexi-dev files are there, so you can get at least a little bit farther.

[Aldrik]

Re: Open/Import Access mdb files with Kexi

Thanks for the input. The only thing is those database drivers (are not needed can connect to mysql fine) & dev files are for 0.9 (current is 1.0) & it looks like I'd need to remove Koffice 1.5 to use the older version.

KOffice-Dev seems to have sorted te KexiDB headers now I stuck for the libraries.

...Ok I give up and compiled koffice & all works fine now