Create a MS Access connection to read from or write to Microsoft Access.
Feature snapshot
Operation
Support
Read
Yes
Write
Yes
Connection properties
The following table describes the connection properties:
Connection property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Data Source Name
System DSN name.
Code Page
The code page compatible with the Microsoft Access source. Select one of the following code pages:
- MS Windows Latin 1. Select for ISO 8859-1 Western European data.
- UTF-8. Select for Unicode and non-Unicode data.
- Shift-JIS. Select for double-byte character data.