When you are scripting data changes in Microsoft Access databases you may need to create temporary tables in order to update the data. This requires using DDL statements like CREATE TABLE. I usually need to lookup the field types since it doesn’t happen very often. Here is a table of types that you can use.
|Desired Type||DDL Syntax|
I got these types from the following Microsoft Support article.