The following is a list of the results and considerations of common data type conversions when the table contains data.
| From | To | Results | Considerations |
|---|---|---|---|
| All data types | AutoNumber | Prohibited by Microsoft Access | None. |
| Text | Number, Currency, Date/Time, Yes/No |
Converts text to appropriate values | Make sure values fit in the new data type; inappropriate values are deleted. |
| Memo | Text | Simple conversion | Data longer than the FieldSize setting is truncated. |
| Number | Text | Converts values to text | Numbers adopt General Number format. |
| Number | Currency | Converts numbers to currency | Make sure values fit in the new data type; inappropriate values are deleted. |
| Date/Time | Text | Converts values to text | Dates or times adopt General Date format. |
| Currency | Text | Converts values to text | Text doesn't include currency symbols, such as $. |
| Currency | Number | Simple conversion | Make sure values fit in the new data type; inappropriate values are deleted. |
| AutoNumber | Text | Converts values to text | Values may be truncated depending on FieldSize setting. |
| AutoNumber | Number | Simple conversion | Values may be truncated depending on FieldSize setting. |
| Yes/No | Text | Converts values to text | None. |