Revision as of 21:51, 27 August 2014 by Jstaniek (talk | contribs) (Created page with "<languages/> <translate> ==Microsoft Access File Formats== <!--T:16--> ===Overview=== <!--T:17--> <!--T:18--> Support for importing '''Microsoft Access''' databases (2003 o...")(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff) Contents 1 Microsoft Access File Formats 1.1 Overview 1.2 Capabilities 1.3 Supported Features 1.4 Unsupported Features Microsoft Access File Formats Overview 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: In Kexi menu select Import, Export or Send.. command. Click Import Database button. Use the import wizard by selecting desired .mdb file. Capabilities 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. 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. During import Kexi skips the following objects: Queries Forms Scripts Reports The following are untested: Importing binary objects Retrieved from "https://userbase.kde.org/index.php?title=Kexi/Handbook/References/Supported_File_Formats/Microsoft_Access_File_Formats&oldid=337531" Categories: KexiTutorials This page was last edited on 27 August 2014, at 21:51. Content is available under Creative Commons License SA 4.0 unless otherwise noted.