Microsoft Access Data Types Mapping

XPO creates these column types when updating the Microsoft Access database schema and expects them in existing databases.

.NET Type Database Column Type
Boolean bit
Byte byte
SByte short
Char char(1)
Decimal currency
Double double
Single single
Int16 short
UInt16 int
Int32 int
UInt32 decimal(10,0)
Int64 decimal(20,0)
UInt64 decimal(20,0)
Guid guid
String varchar
DateTime datetime
TimeSpan double
Byte[] longbinary
Unlimited size string LONGTEXT
See Also