Kexi is capable of importing and exporting data from/to a variety of Comma-separated values formats (CSV files). Most spreadsheet and database applications can import and export in this format, making this an appropriate format to migrate textual data between different applications.
Kexi also supports a number of options that can be configured before performing import:
On importing Kexi shows preview of imported data. Most suitable set of options is auto-detected by Kexi based on provided CSV file.
Support for importing Microsoft Access databases (2003 or older) is built into Kexi. Access databases can be imported 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. Importing .accdb databases introduced in MS Access 2007 are not currently supported.
To import a database:
The import function has successfully been used to import Northwind database well known to MS Access users. Many other Access template databases can be also imported.
Importing the following field types has been tested, and generally works well:
Currently, only tables are imported. During import Kexi skips the following objects:
The following are untested: