Share via


Remote View Wizard

Creates views using remote data (ODBC). You must have an existing database to store your view in as well as an existing data source or connection. If you do not have a database open, you are prompted to select an existing database or create one.

Before you run the Remote View Wizard, you can set options for remote view and connection defaults on the Remote Data tab, Options dialog box. You can create connections in the Connection Designer.

To run the Remote View Wizard

  1. From the Wizards submenu on the Tools menu, choose Query.
  2. In the Wizard Selection dialog box, choose Remote View Wizard.

Wizard Steps

Remote View Wizard: Step 1 - Choose Data Source
Remote View Wizard: Step 2 – Select Fields
Remote View Wizard: Step 3 – Relate Tables
Remote View Wizard: Step 3a - IncludeRecords
Remote View Wizard: Step 4 – Sort Records
Remote View Wizard: Step 5 - FilterRecords
Remote View Wizard: Step 6 -Finish

See Also

Execution of ODBC Extensions to SQL | ODBC Registry | Cross-Tab Wizard | Graph Wizard | Local View Wizard | Query Wizard | Wizards Overview | Remote Data Tab, Options Dialog Box | Connection Designer