The KOffice Project Microsoft Access (MDB) Filter
Overview
Support for importing Microsoft Access databases is available as separate plugin for Kexi. For more information, see the Download section below
The plugin can be used to import Access databases into a Kexi database only: it cannot be used to edit the database, nor to export to an Access database. However, it should also be able to import databases created by other applications that use the JET database engine.
Download
The MDB plugin is currently distributed as separate plugin for Kexi, but may be packaged for your distribution:
| Distribution | Package Name |
|---|---|
| Debian | kexi-mdb-plugin |
| Ubuntu/Kubuntu | kexi-mdb-driver |
| FreeBSD | ports/databases/keximdb |
The source code for the MDB plugin for KOffice 1.6 (and Kexi 1.1) is available from the KDE ftp server.
Status
The filter has successfully been used to import the famous 'Northwind' database, which can be downloaded (as an executable 'exe' installer) from the Microsoft web-site here (please check the license before installing). Other Access template databases are available from the Microsoft Office Online Access Templates pages.
Supported features
Importing the following field types has been tested, and generally works well:
- Text fields
- Memo fields
- Date fields
- Numeric values
Unsupported features
Currently, only tables are imported. No attempt is made to import the following:
- Queries
- Forms
- Scripts
- Reports
- etc.
The following are untested:
- Importing binary objects
