List of Supported Formats

Search the Online Transformer Gallery

Microsoft Access (JDBC) Writer: 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.
Type

Choose one of the following field types.

Closedautonumber

Used to generate an automatically incremented numeric counter. Only one autonumber field is allowed in each table.

Closedbyte

Represents 8-bit unsigned integers.

Closedcurrency

Represents monetary data values up to 15 digits of whole dollars and 4 decimal places.

Closeddatetime

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.

See Standard FME Date/Time Format.

Closeddecimal

Represents fixed precision and scale numeric data from -10^28-1 through 10^28-1.

Closeddouble

Represents 64-bit floating precision numbers.

Closedinteger

Represents 16-bit signed integers.

Closedlong

Represents 32-bit signed integers.

Closedmemo

Represents character data up to a length of 65,536 characters.

Closedoleobject

Represents binary large objects. The data must be specially formatted to be read correctly in Microsoft Access.

Closedreplicationid

Represents GUIDs. As such, it must be set up like a valid GUID. For example: {B85E62C3-DC56-40C0-852A-49F759AC68FB}

Closedsingle

Represents 32-bit floating precision numbers.

Closedtext

Represents character data up to a length of 255 characters.

Closedyesno

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 listed below:

PrimaryKey: This type specifies that the column is a primary key for the table. Only one primary key is allowed per table.

Unique: This type specifies that the column has a UNIQUE constraint.

NotNull: A non-nullable constraint.