| Numeric types | |||||
| Access | MySQL | MSSQL | |||
| Byte | 1 byte | TINYINT(size) | bigint | 1 byte | |
| Integer | 2 bytes | SMALLINT(size) | smallint | 2 bytes | |
| Long | 4 bytes | MEDIUMINT(size) | int | 4 bytes | |
| Single | 4 bytes | INT(size) | bigint | 8 bytes | |
| Double | 8 bytes | BIGINT(size) | decimal(p,s) | 5-17 bytes | |
| Currency | 8 bytes | FLOAT(size,d) | numeric(p,s) | 5-17 bytes | |
| AutoNumber | 4 bytes | DOUBLE(size,d) | smallmoney | 4 bytes | |
| DECIMAL(size,d) | money | 8 bytes | |||
| float(n) | 4 or 8 bytes | ||||
| real | 4 bytes | ||||
| String / text types | |||||
| Access | MySQL | MSSQL | |||
| Text | CHAR(size) | char(n) | Defined width | ||
| Memo | VARCHAR(size) | varchar(n) | 2 bytes + number of chars | ||
| Byte | 1 byte | TINYTEXT | varchar(max) | 2 bytes + number of chars | |
| TEXT | text | 4 bytes + number of chars | |||
| nchar | Defined width x 2 | ||||
| nvarchar | |||||
| nvarchar(max) | |||||
| ntext | |||||
| bit | |||||
| binary(n) | |||||
| varbinary | |||||
| varbinary(max) | |||||
| image | |||||
| Date types | |||||
| Access | MySQL | MSSQL | |||
| Date/Time | 8 bytes | DATE() | datetime | 8 bytes | |
| DATETIME() | datetime2 | 6-8 bytes | |||
| TIMESTAMP() | smalldatetime | 4 bytes | |||
| TIME() | date | 3 bytes | |||
| YEAR() | time | 3-5 bytes | |||
| datetimeoffset | 8-10 bytes | ||||
| timestamp | |||||
| Other data types | |||||
| Access | MySQL | MSSQL | |||
| Yes/No | 1 bit | sql_variant | |||
| Ole Object | up to 1GB | uniqueidentifier | |||
| Hyperlink | xml | ||||
| Lookup Wizard | 4 bytes | cursor | |||
| table | |||||