Data type mapping from Ms Access to MySql

Ms Access (Max) Size MySQL

Boolean 1-bit TinyInt
N Byte 1-Byte TinyInt Unsigned
N Integer 2-Byte SmallInt
N Long Integer 4-Byte Integer
N Single 4-Byte Float
N Double 8-Byte Double
Currency 8-Byte Decimal (20, 4)
N Decimal 12-Byte Decimal (M, D)
Text 256 B VarChar (Size)
Date/Time 8-Byte DateTime
OLE 1 G MediumBlob
Memo 64 KB Text
Autoincrement 4-Byte Integer with autoincrement property