The Access connector is an object that is used to export data to Microsoft Access files (*.mdb).
After adding the connector to the ETL task workspace, set basic properties and export options. The connector input and output can be also edited, and error handling parameters can also be set.
The Export Options page is used to specify a database file for data export.
Specify path to the Microsoft Access file, to which the data should be loaded.
Data is loaded to the table selected in the Table drop-down list. The list contains all tables of the selected database.
Selecting the Clear Consumer Before Loading Data checkbox enables the user to delete all information from the consumer table before data loading.
See also: