Microsoft Access Connections

When you create or update a Microsoft Access connection, you can configure additional attributes, such as the connection ID and the connection name.

The following table describes attributes that you can use for Microsoft Access connections:

Attribute

Description

id

Connection ID

orgid

Organization ID.

name

Connection name.

description

Optional connection description.

type

Connection type. Use CSVFile.

database

Directory on a local machine that stores the local file. In the user interface, this attribute is the Directory field. In the REST API response that populates the value in the user interface, the name of this attribute is dirName.
The local machine must also run the Secure Agent used to run the corresponding task. Enter a local directory or use the Browse button to select a local directory.

codepage

The code page of the system that hosts the flat file. Use one of the following options:
UTF-8. Unicode Transformation Format, multibyte.
MS1252. MS Windows Latin 1 (ANSI), superset of Latin 1.
ISO-8859-15. Latin 9, Western European.
ISO-8859-2. Eastern European.
ISO-8859-3. Southeast European.
ISO-8859-5. Cyrillic.
ISO-8859-9. Latin 5, Turkish.
IBM500. IBM EBCDIC International Latin-1.

agentid

Secure Agent ID