Analysis Datatypes Mapping to Access Datatypes

Here's a mapping from the analysis datatypes to Access Datatypes.

Thanks to Jim Connell of Custom Software, the Access expert who provided this mapping.

Analysis Datatypes Mapping to Access Datatypes

Analysis Datatype Name	Corresponding Access Datatype Name	Note
indicator	Byte
code	Number or Text	if Number, then integer
datetime	Date/Time
date	Date/Time
time	Date/Time
money	Number	Double, although a single or a decimal could be used; early versions of Access had imprecision with singles, so doubles are the recommended field type
amount	Number	Double; a second text field would be used for units
quantity	Number	Integer
sequence number	Number	Integer
address	Text	typically requires multiple columns, one for each portion of the address
phone number	Text
email address	Text
internet address	Hyperlink
identifier	Text
name-person	Text	typically requires multiple columns, one for each portion of a person's name
name-organization	Text
name-other	Text
specification text	Text
text	Text	potentially Memo if length is greater than 255 characters
encoded data	OLE Object
ratio	Number	Double; depending on the needed precision, decimal is a possibility