 | This guide will help you learn hot to read and write data from/to Microsoft Access database (.mdb files). |
Linux Users
Please note that if you are using this connector on a Linux machine, you need to have ODBC driver installed.
Configuration
To start working with MS Access tables,
- Drag-and-drop MS Access connector to Apatar's work panel.
- Double-click on the connector. Property window will pop up.
- Fill in the configuration details (database file name, user name, and password).
- Click Next.
- The list of MS Access tables occurs. Make a selection and choose a table you would like to extract data from or write data to.
- Click Next. If all of the previous actions were performed correctly, you will see the names of the data fields.
- Click Finish.
If necessary, you can preview the data entries. To do so, right-click on the connector and choose "Preview Results".