Data type mapping from MySql to Access

MySQL Ms Access Size

Date : 3B
Time : 3B
DateTime : 8B
TimeStamp : 4B Date/Time 8B

Char : L255
VarChar : L255 Text /

Float : 4B N Single 4B

Double/Real:8B N Double 8B

TinyInt : 1B
Year : 1B N Byte 1B

SmallInt : 2B N Integer 2B

Integer/Int : 4B
MediumInt : 3B N Long Integer 4B

TinyText : L255
Text : L64KB
MediumText : L16MB
LongText : L4GB Memo /

TinyBlob : L255
Blob : L64KB
MediumBlob : L16MB
Longblob : L4GB OLE object /

Decimal/Numeric (M,D) N Decimal (M,D) 8B

All Integer
fields with
auto_increment
property Increment 4B

BigInt : 8B Text 20B