[faq] field (column) type summary - gordthompson/sqlalchemy-access GitHub Wiki

Name	Comments
AutoNumber	"Long Integer"-type only
Byte	8-bit unsigned integer, 0 ≤ value ≤ 255
Char(n)	fixed-length Unicode, padded with spaces, 1 ≤ n ≤ 255
Currency
DateTime
Decimal(m, n)	m = precision, n = scale
Double	64-bit IEEE floating point
Integer	16-bit signed integer, -32_768 ≤ value ≤ 32_767
LongInteger	32-bit signed integer, -2_147_483_648 ≤ value ≤ 2_147_483_647
LongText	was: "Memo"
OleObject	large raw binary object (not automatically OLE-encoded)
ReplicationID	a.k.a. "UUID"
ShortText(n)	1 ≤ n ≤ 255
Single	32-bit IEEE floating point
YesNo	not NULLable; inserting NULL (None) actually inserts False

Sample usage:

import sqlalchemy_access as sa_a

dtype_dict = {'product_name': sa_a.ShortText(50), 'price': sa_a.Currency}
df.to_sql("product", engine, if_exists="replace", index=False, dtype=dtype_dict)