Microsoft Access DDL Types

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
Text TEXT(50)
Memo MEMO
Byte BYTE
Integer INTEGER
Long LONG
AutoNumber COUNTER
Single SINGLE
Double DOUBLE
Currency CURRENCY
ReplicaID GUID
DateTime DATETIME
YesNo YESNO
OleObject LONGBINARY
Binary BINARY(50)

I got these types from the following Microsoft Support article.

http://support.microsoft.com/kb/180841

Advertisements
Tagged with: ,
Posted in Development

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: