Map Query fields to Access - Automate_Studio - Latest

Automate Studio with Studio Administrator User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
Language
English
Product name
Automate Studio
Title
Automate Studio with Studio Administrator User Guide
Topic type
Administration
Overview
How Do I
Installation
First publish date
2018
ft:lastEdition
2024-03-11
ft:lastPublication
2024-03-11T17:14:05.914572
  1. Click the Mapper tab, or click the Map tab on the ribbon. You can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words).

  2. Do one of the following:
    • Click Auto Map.
    • Drag each field from the Mapper to the data file preview.
    • Click Add Column and add each field.
    • Open an existing database file and drag fields to the columns.
    Tip: Tips: If you are using a new, unnamed database file, you can rename or delete a table: Right-click the table name in the Data Set panel, and then choose the option that you want.If Access has been configured incorrectly, Studio may crash when you click "Start Access." Configure Access correctly to resolve the issue.

The next step is to run the query.