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 |
