Skip to main content

Write Access

Synopsis​

This operator writes an ExampleSet into the specified Microsoft Access database.

Description​

The Write Access operator is used for writing an ExampleSet into the specified Microsoft Access database (.mdb or .accdb extension) using the UCanAccess jdbc driver. You only need to have a basic understanding of databases in order to use this operator properly. Please go through the parameters and the attached Example Process to understand the working of this operator.

Input​

input​

This input port expects an ExampleSet. It is output of the Retrieve operator in the attached Example Process.

Output​

through​

The ExampleSet that was provided at the input port is delivered through this output port without any modifications. This is usually used to reuse the same ExampleSet in further operators of the process.

file​

This port memory buffers file object for passing it to the reader operators

Parameters​

Database file​

This parameter specifies the path of the Access database ( i.e. the mdb or accdb file)

Username​

This parameter is used for specifying the username of the database (if any).

Password​

This parameter is used for specifying the password of the database (if any).

Table name​

This parameter is used for specifying the name of the required table from the specified database.

Overwrite mode​

This parameter indicates if an existing table should be overwritten or the data should be appended.

Access version​

If a new database is created this parameter specifies its format version. This parameter is not used if the database already exists.