Access Data Mapping Wizard

To extract data from a MySQL database using the data mapping wizard, the following steps are involved:

• Start by opening the Creating a New Data Mapping Configuration wizard.
• In the list, select Data mapping Wizards -> From databases and click Next.
• In the Database type drop-down, select Microsoft Access and click Next.
• Enter the appropriate information to connect to the database:
• • Filename: Browse to your Microsoft Access database file (.mdb)
  • Password: Enter a password if one is required.
• Click Next and enter the information for the source table.
• • Connection string: Displays the full path to the database.
  • Table: Use the drop-down to select the appropriate table or stored query to retrieve the appropriate data set.
  • Encoding: Use the drop-down to select the encoding with which to read the data in the table.
• Click Finish to save the configuration.