Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| Microsoft Access | CData Schema |
| ID | long |
| Text | string |
| Memo | string |
| Byte | tinyint |
| Integer | int |
| Long | long |
| Single | float |
| Double | float |
| Currency | decimal |
| Date/Time | datetime |
| Yes/No | bool |