MS Access from Mac OS X?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
spohrerga
Posts: 1
Joined: Tue Sep 28, 2010 4:22 pm

MS Access from Mac OS X?

Post by spohrerga »

From what I can tell, OpenOffice is supposed to open MS Access files - "You can connect to an Access file in OpenOffice.org. Choose File > New > Database, choose to connect to an existing database, choose Access as the format, and click Next."

However, in the Mac OS X version of OpenOffice, Access is not listed as one of the supported database types. Does this mean I need an ODBC or JDBC driver?

Thanks

George
OpenOffice 3.2.1 on Mac OSX 10.6.4
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: MS Access from Mac OS X?

Post by r4zoli »

Ask Microsoft to provide drivers for Mac, then you can work with access files on Mac.
Until that convert access to real database, for example postgesql or mysql, and use OOo Base as front-end.

Second option export data from access as csv, and import it into any database.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply