Microsoft Access User Attributes
For information on the parameters in this dialog that are common to all readers, see:
For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
Name |
The name of the field to be written. Valid values for field name include any character string devoid of SQL-offensive characters and less than 128 characters in length. |
Type |
The type of a column in a table. The valid values for the field type are listed below: autonumber
Used to generate an automatically incremented numeric counter. Only one autonumber field is allowed in each table. byte
Represents 8-bit unsigned integers. currency
Represents monetary data values up to 15 digits of whole dollars and 4 decimal places. datetime
Represents date and time data January 1, 0100 to December 31, 9999 with an accuracy of 3.33 milliseconds. Note: FME accurately represents data only after the date October 15, 1582. decimal
Represents fixed precision and scale numeric data from -10^28-1 through 10^28-1. double
Represents 64-bit floating precision numbers. Hyperlink
Represents a hyperlink associated with a control. integer
Represents 16-bit signed integers. long
Represents 32-bit signed integers. memo
Represents character data up to a length of 65,536 characters. oleobject
Represents binary large objects. The data must be specially formatted to be read correctly in Microsoft Access. replicationid
Represents GUIDs. As such, it must be set up like a valid GUID. For example: {B85E62C3-DC56-40C0-852A-49F759AC68FB} single
Represents 32-bit floating precision numbers. text
Represents character data up to a length of 255 characters. yesno
Represents a logical field with a value of True or False. Nulls are automatically changed to False in yesno fields. |
Index |
The types of indexes and constraints to create for the column, if the table is created. Indexes and constraints are only created if the table is created. Each index and constraint contains only one column. The valid values for the column type are:
|