Export Properties: Microsoft Access

GENERAL PROPERTIES

Table Name

This setting specifies the table name data will be exported to. Enter the name of the table to which data will be exported. You can embed macros (of the form &[macro]) in the table name. 

In creating a table name, the following rules apply: 

• Table names must be between 1 and 64 characters
• They must not start or end with whitespace characters
• They must not contain the following characters: . ! ` [ ]

Note that issues in compliance with these rules will prevent you from performing the export. Hover your mouse over the Table Name field to display the rules to consider in creating your table name.

Show Tables

When exporting a table to a file that already exists, this setting allows you to see the destination file’s existing tables and columns and select the table to which the data should be appended or overwritten. When a table from the Show Tables dialog is selected and confirmed, the name of the selected table is inserted into the Table Name textbox and the current content of this box is overwritten.

The tables displayed in the Show Tables dialog may be sorted by name by clicking on the sort icon in the header. The tables have an expander button that allows you to view a list of columns belonging to that table.

File Extension

This setting specifies the extension to use for the export file. It is enabled only when the Filter setting is set to All Filters and the Automatic Naming setting is set to By Files.

Filter

This setting specifies what filter to apply to the table when it is exported.

When All Filters is selected as a filter option, you will be asked to specify your desired Automatic Naming setting:

• by Files: produces a file for each filter

• by Tables: produces a table for each filter

Sort

This setting specifies what sort to apply to the table when it is exported.

When File Exists

This setting specifies what Data Prep Studio should do if a file with the same name exists in the folder you specified in the Export Location field. Select an action if the export file already exists:

• Overwrite the file

• Append records to the existing file

• Skip the export operation

When Table Exists

This setting specifies what Data Prep Studio should do if a table or sheet with the same name you specified exists in the file you indicated in the Export Location field. Select an action if the export table already exists:

• Overwrite the table.

• Append records to the existing table

• Skip the export operation.

SUMMARY-SPECIFIC SETTINGS

Summary 

If the table to be exported is a summary, this setting specifies which summary to include in the export.

NOTE: The filter selected in the general settings is applied to the selected summary if this summary uses the "Default Filter."

Measure

This setting specifies which measure should be applied to the exported summary.

It is enabled when only a column key is defined in the summary.

Split

This setting instructs the application to create a separate file or table when a distinct value of the first key is encountered in a summary. 

This setting is enabled in the following cases:

• When All Summaries is selected in the Summary setting
• When All Measures as separate exports is selected in the Measure setting
• When the Split setting is selected

The following options then become available:

• by Files: produces a file for each summary, measure, or distinct value of the first key 

• by Tables: produces a table for each summary, measure, or distinct value of the first key 

Drill Level

Specifies the drill level to apply to the exported summary. A higher drill level indicates more columns displayed in the output table. You can also choose to use the current drill level specified in the summary.