DataWright Information Services
Consulting and Resources for Excel and Access
Data Types in Jet, DDL and ADOX
The following table shows the data types that can be created through the Access Jet interface, and their equivalents in DDL (SQL) and ADOX.
| Access Interface | DDL (Queries) | ADOX constant |
|---|---|---|
| Text | Text (size) | adVarWChar |
| Memo | Memo | adLongVarWChar |
| Number -- Byte | Byte | adUnsignedTinyInt |
| Number -- Integer | Short | adSmallInt |
| Number -- Long | Long | adInteger |
| Number -- Single | Single | adSingle |
| Number -- Double | Double | adDouble |
| Number -- Replica | GUID | adGUID |
| Number -- Decimal | Decimal (precision, scale) | adNumeric |
| Date/Time | DateTime | adDate |
| Currency | Currency | adCurrency |
| Auto Number | Counter (seed, increment) | adInteger with attributes |
| Yes/No | YesNo | adBoolean |
| OLE Object | LongBinary | adLongVarBinary |
| Hyperlink | adLongVarWChar with attributes |
