Dashboard > APATAR CONNECTOR GUIDES > Apatar Connector Guides > Connector for MS Access
  APATAR CONNECTOR GUIDES Log In | Sign Up   View a printable version of the current page.  
  Connector for MS Access
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on May 19, 2008  (view change)
Labels: 
(None)

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,

  1. Drag-and-drop MS Access connector to Apatar's work panel.



  2. Double-click on the connector. Property window will pop up.
  3. Fill in the configuration details (database file name, user name, and password).



  4. Click Next.
  5. 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.
  6. Click Next. If all of the previous actions were performed correctly, you will see the names of the data fields.
  7. Click Finish.

If necessary, you can preview the data entries. To do so, right-click on the connector and choose "Preview Results".

Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators