Access data types are differently named from SQL Server data types. For example, a SQL Server column of the bit data type is imported or linked into Access with the Yes/No data type. The following table compares SQL Server and Access data types.
| SQL Server data type | Access data type | Access field size |
|---|---|---|
| bigint | Large Number | For more information, see Using the Large Number data type. |
| binary (field size) | Binary | Same as SQL Server field size |
| bit | Yes/No | |
| char (field size), where field size is less than or equal to 255 | Text | Same as SQL Server field size |
| char (field size), where field size is greater than 255 | Memo | |
| datetime | Date/Time | Double-precision floating point |
| datetime2 | Date/Time Extended | Encoded string of 42 bytes. For more information, see Using the Date/Time Extended data type. |
| decimal (precision, scale) | Number | Decimal (Access Precision and Scale properties match SQL Server precision and scale.) |
| float | Number | Double |
| image | OLE Object | |
| int | Number | Long Integer |
| money | Currency | |
| nchar (field size), where field size is less than or equal to 255 | Text | Same as SQL Server field size |
| nchar (field size), where field size is greater than 255 | Memo | |
| ntext | Memo | |
| numeric (precision, scale) | Number | Decimal (Access Precision and Scale properties match SQL Server precision and scale.) |
| nvarchar (field size), where field size is less than or equal to 255 | Text | Same as SQL Server field size |
| nvarchar (field size), where field size is greater than 255 | Memo | |
| nvarchar(MAX) | Memo | |
| real | Number | Single |
| smalldatetime | Date/Time | |
| smallint | Number | Integer |
| smallmoney | Currency | |
| sql_variant | Text | 255 |
| text | Memo | |
| timestamp | Binary | 8 |
| tinyint | Number | Byte |
| uniqueidentifier | Number | Replication ID |
| varbinary | Binary | Same as SQL Server field size |
| varbinary (MAX) | OLE Object | |
| varchar (field size), where field size is less than or equal to 255 | Text | Same as SQL Server field size |
| varchar (field size), where field size is greater than 255 | Memo | |
| varchar(MAX) | Memo | |
| xml | Memo |