# Converting Access Databases to SQLite

## Native SQLite support

Converting data to SQLite could not be any easier: Just click the "Export SQLite" button in the toolbar. You can export either all tables or only selected tables. (Press ⌘ or ⇧ while clicking to select more than one table in the sidebar)

MDB Viewer transfers all data to the SQLite database, even OLE fields and attachments. The following table describes how Access column types are mapped to SQLite.

### Access Types vs. SQLite Types

Access Type | SQLite Type
--- | ---
Boolean | BOOLEAN
Byte | INTEGER
Integer | INTEGER
Long Integer | INTEGER
GUID | TEXT
Decimal | DOUBLE
Currency | DOUBLE
Float | DOUBLE
Double | DOUBLE
Date/Time | DATETIME
Text | TEXT
Memo | TEXT
Ole | BLOB

## SQLite compatible SQL dumps

MDB Viewer also supports exporting SQLite compatible SQL scripts. These allow exporting table structure and contents separately. SQL files are also very convenient if you want to add tables to exisiting databases, or if you would like to use different column types. You can just change the SQL file manually with a text editor.

Read more about SQL dumps in the section Exporting as SQL