Microsoft Access

The Microsoft Access connectors allows data to be retrieved from a MS Access file.

NOTE: For MS Access, it is recommended to install the appropriate 32-bit or 64-bit version of the ACE driver to the corresponding Panopticon Designer (Desktop) version.

Using Microsoft Access

  1. When creating a new data table, select Access from the Connect to data dialog.

  2. Select a file type in the Open dialog that is displayed.

Then select the desired file in the list. The Access Connection dialog box is displayed.

  1. You can opt to click Browse to select an alternate file.

  2. Select which Table to display the column names in the Schema list box.

  1. Check the Select box of the columns.

  2. Click OK. The source table is returned in the Data Prep with the title of the MS Access file selected and the fields displayed in the Data Source Preview.