SQLite
Access

SQLite to Access Converter

SQLite tables, keys, and rows in an Access file, with each column's Access field type reviewed before the run.

Version
5.4.2
Release Date
Oct. 28, 2026
Size
122.6 MB
Platform
Windows 10 or later
Download DBConvert Order from US$ 199

Rather not run it yourself?

Let us do the migration →

Move a SQLite database into Microsoft Access without building the Access tables by hand. DBConvert reads the SQLite file, proposes an Access field type for every column, and creates the tables, indexes, and relationships before copying the rows.

  • Reads a SQLite database file: .db, .sqlite, .sqlite3, or .db3.
  • Creates an .accdb or .mdb file, with a database password if you set one.
  • Runs on Windows as a desktop application.
  • The same download converts Access back into SQLite.

Decide the Access structure before the first run

Connections, table selections, and mappings stay on screens you can return to while you prepare the file.

Select the tables

Pick the tables to copy and add a row filter when only part of a table belongs in Access.

Review the field types

See the Access type proposed for each column and change it before the run. A value that does not fit its Access field is reported with the table and column, never stored as an empty value.

Save the job

Keep the connections, table selection, and options in a job, and run it again when the SQLite data changes.

Convert once, or keep Access in step with SQLite

Conversion and synchronization are modes of one DBConvert application.

One-time conversion

Create the Access file with its tables and rows, then open it in Access and check the data before users rely on it.

Scheduled synchronization

Apply the inserts, updates, and deletes made in SQLite to the Access file on a schedule; a second job sends Access changes back to SQLite. A row that cannot be written is reported, and the rows after it still land. See how synchronization works.

When Access is the right target

Office users and Access tools

Give people who work in Access forms, reports, and queries the data an application collected in SQLite.

Data for an existing Access application

Feed an Access application from a SQLite file produced elsewhere, such as a mobile or field app, and refresh it with a saved synchronization job.

What the Access side needs

DBConvert writes Access files through Microsoft's Access Database Engine. It is not part of the DBConvert installer.

  • The 64-bit Access Database Engine. A free Microsoft download, not part of the DBConvert installer; if it is missing, Connect says so and links to Microsoft's download.
  • An existing target in Access 2000 format or later. Access 97 files cannot be opened.
  • A database password is supported. Workgroup security (.mdw files) is not.
  • Room for the data: Microsoft limits an Access file to 2 GB. Filter large tables before loading.

How SQLite types map to Access

SQLite keeps any value in any column; Access enforces the field type. The declared SQLite type decides the Access field, and a type name DBConvert does not list follows SQLite's own affinity rules.

In SQLite DBConvert default in Access What needs attention
Integer types INTEGER becomes Long Integer, SMALLINT Integer, TINYINT Byte. BIGINT, INT8, and unsigned types become Decimal with no scale. Every number keeps its range. A value too large for its Long Integer field is reported, not cut.
NUMERIC(p,s), DECIMAL(p,s), floating point A declared precision becomes Decimal(p,s), up to Access's 28 digits. REAL, FLOAT, DOUBLE, and NUMERIC without a precision become Double. Declare a precision in SQLite, or set Decimal in the mapping, where values must stay exact.
Text types VARCHAR(n) and CHAR(n) up to 255 become Short Text(n). Longer, unsized, TEXT, and CLOB columns become Long Text. SQLite never limited text length, so an unsized column gets Long Text rather than a guessed width.
Dates and times DATE, DATETIME, TIMESTAMP, and TIME become Date/Time. A time alone is stored on 30 December 1899, Access's day zero. A value with Z or an offset such as +02:00 is stored as its UTC time. Dates kept in plain text or integer columns are not detected.
BOOLEAN, GUID / UUID, BLOB Yes/No, Replication ID, and OLE Object respectively. A GUID is accepted as 36-character text, 32 hex digits, or a 16-byte blob. Anything else in that column is reported.
Keys and defaults INTEGER PRIMARY KEY AUTOINCREMENT becomes AutoNumber; a plain INTEGER PRIMARY KEY stays a Long Integer key. CURRENT_TIMESTAMP becomes Now(), CURRENT_DATE becomes Date(). Composite keys, indexes, and foreign keys are created. A default built from another expression is dropped and named in the log.

Views and triggers need a separate pass

DBConvert moves tables with their fields, indexes, and primary and foreign keys. SQLite views, triggers, and CHECK expressions are not converted; recreate what the Access application needs as Access queries or validation rules.

Supported versions and services

SQLite

  • SQLite 3.0 and later

Access

  • MS Access .accdb, and .mdb in Access 2000 format or later
  • Database password; the 64-bit Microsoft Access Database Engine is required
SQLite

All SQLite Tools

Other directions and pairs
Access

All Access Tools

Migration & sync options

Reverse Conversion

Access to SQLite

DBConvert Studio

30+ databases · cloud · scheduled sync

Need more database pairs? One tool covers 30+ databases.

How to migrate SQLite to Access

1

Setup: connect SQLite and Access

Pick Convert or Sync, then choose the source and destination connections side by side on one screen. A connection is saved once and reused by every job.

The Setup step in DBConvert: the mode, the SQLite source and Access destination side by side, and the job name

Sync keeps an existing Access database up to date with SQLite: each run carries only the inserts, updates and deletes since the last one.

The Setup step in Sync mode for SQLite to Access: how changes are detected and the direction

SQLite source

Select the source SQLite database file - .sqlite, .sqlite3, .db or .db3.

Access target

Name the .accdb or .mdb file to create, with a database password if you want one. Writing it needs the 64-bit Microsoft Access Database Engine; Microsoft caps an Access file at 2 GB.

2

Tables & mapping: see every Access type before a row moves

Pick the tables, then open one: each SQLite column shows the Access type it becomes. Change a type or a name in place; the line at the bottom names anything that would fail.

Tables and mapping for SQLite to Access: the table list and one table's columns with their Access types

Every option, in the guide

Naming rules, table options, row filters, scheduling and the command line work the same for every database pair, so they live in one place.

See all features

More guides for SQLite ↔ Access

Move SQLite data into Access

Download the current build and run the first job against your own database.

Download DBConvert 5.4.2 Order from US$ 199

Windows Windows 10 or later · 122.6 MB