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 |