Can't Import mdb file under linux hardy (OO 2.4)

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
alobo
Posts: 2
Joined: Tue May 13, 2008 3:00 pm

Can't Import mdb file under linux hardy (OO 2.4)

Post by alobo »

Hi!
I can't import an mdb file into OO 2.4 Base (ubuntu hardy). I can do it
under windows, using the "connect to an existing database",
but don't figure out how to do it in Linux. I've tried
with ODBC and JDBC, I suspect I have some
driver missing, but I'm pretty lost.
Any help would be appreciated!

Thanks
Agus
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Can't Import mdb file under linux hardy (OO 2.4)

Post by r4zoli »

No stable ODBC driver for mdb file under linux, in consequence OOo not support mdb file under linux, now. (earlier was a test driver, but it fails very often)
rdinning
Posts: 1
Joined: Thu May 15, 2008 4:50 am

Re: Can't Import mdb file under linux hardy (OO 2.4)

Post by rdinning »

I can't import a very simple Access Data Base into OO Base at all in Windows XP Pro SP2. All that shows up is gibberish.

I just downloaded OO this evening and installed it.

Any ideas?
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Can't Import mdb file under linux hardy (OO 2.4)

Post by r4zoli »

You can not open mdb or other MSA files, only connect to them to retrieve tables, forms, reports not usable. details in OOo wiki page.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
alobo
Posts: 2
Joined: Tue May 13, 2008 3:00 pm

Re: Can't Import mdb file under linux hardy (OO 2.4)

Post by alobo »

r4zoli wrote:No stable ODBC driver for mdb file under linux, in consequence OOo not support mdb file under linux, now. (earlier was a test driver, but it fails very often)
But gmdb2 (http://mdbtools.sourceforge.net/) is able to open it
and save the tables as csv, why not Base?
Anyway, that's the way I found to get the mdb diles into linux.

Agus
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Can't Import mdb file under linux hardy (OO 2.4)

Post by r4zoli »

This was an unfinished attempt to build an usable ODBC driver, which gave false results, unstable, and scrappy, for this reason not supported by OOo.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply