Advertisements

Comparing Access and SQL Server data types

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.

Access data types are distinctly labelled 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 below table evaluates both SQL Server and Access data types.

SQL Server data typeAccess data typeAccess field size
bigintLarge NumberSee Using the Large Number data type.
binary (field size)BinarySame as SQL Server field size.
bitYes/No
char (field size), where field size is less than or equal to 255TextSame as SQL Server field size.
char (field size), where field size is greater than 255Memo
datetimeDate/Time
decimal (precision, scale)NumberDecimal (Access Precision and Scale properties match SQL Server precision and scale.)
floatNumberDouble.
imageOLE Object
intNumberLong Integer.
moneyCurrency
nchar (field size), where field size is less than or equal to 255TextSame as SQL Server field size.
nchar (field size), where field size is greater than 255Memo
ntextMemo
numeric (precision, scale)NumberDecimal (Access Precision and Scale properties match SQL Server precision and scale.)
nvarchar (field size), where field size is less than or equal to 255TextSame as SQL Server field size.
nvarchar (field size), where field size is greater than 255Memo
nvarchar(MAX)Memo
realNumberSingle.
smalldatetimeDate/Time
smallintNumberInteger.
smallmoneyCurrency
sql_variantText255
textMemo
timestampBinary8
tinyintNumberByte.
uniqueidentifierNumberReplication ID.
varbinaryBinarySame as SQL Server field size.
varbinary (MAX)OLE Object
varchar (field size), where field size is less than or equal to 255TextSame as SQL Server field size.
varchar (field size), where field size is greater than 255Memo
varchar(MAX)Memo
xmlMemo

Advertisements

Leave a Reply

%d bloggers like this: