Microsoft Access (ACCDB and MDB)

2010 Office System Driver: Access Database Engine (32-bit)
2007 Office System Driver: Data Connectivity Components

SQL Language: Microsoft Jet Database Engine Programmer's Guide

The Office System Drivers are also installed with Microsoft Office.
SQL Offline requires 32-bit drivers. If you have a 64-bit version of Office installed, you can install the 2007 Office System Driver.

Column Types

Access Column Type List

access column types
Access provider types

Additional qualifiers can be added. For example,


will specify that a field defaults to the time the record was appended. The Access provider type will be passed directly to the CREATE TABLE command and retained in the .OL grid file.

SQL Offline © 2014 Interscape Corporation