Jump to content

Kexi/Handbook/References/Supported File Formats/Microsoft Access File Formats: Difference between revisions

From KDE Wiki Sandbox
Jstaniek (talk | contribs)
KDEDevelopers, spam-ninja, trusted
545 edits
Created page with "<languages/> <translate> ==Microsoft Access File Formats== <!--T:16--> ===Overview=== <!--T:17--> <!--T:18--> Support for importing '''Microsoft Access''' databases (2003 o..."
 
Jstaniek (talk | contribs)
KDEDevelopers, spam-ninja, trusted
545 edits
m KEXI uppercase
 
Line 7: Line 7:


<!--T:18-->
<!--T:18-->
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 <tt>.accdb</tt> databases introduced in MS '''Access''' 2007 are not currently supported.
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 <tt>.accdb</tt> databases introduced in MS '''Access''' 2007 are not currently supported.


<!--T:19-->
<!--T:19-->
Line 52: Line 52:


<!--T:32-->
<!--T:32-->
Currently, only tables are imported. During import '''Kexi''' skips the following objects:
Currently, only tables are imported. During import '''KEXI''' skips the following objects:


<!--T:33-->
<!--T:33-->

Latest revision as of 02:29, 20 December 2024


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:

  1. In Kexi menu select Import, Export or Send.. command.
  2. Click Import Database button.
  3. 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://wikisandbox.kde.org/index.php?title=Kexi/Handbook/References/Supported_File_Formats/Microsoft_Access_File_Formats&oldid=497543"