EMS logo

Products Navigation

Data Export for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Export for SQL Server

On-line Documentation

Access options


This tab allows you to set options for the target MS Access (*.mdb) and MS Access 2007 (*.accdb)file.

 

Set the name for the target table and specify whether the wizard should create a new table in the MS Access database if it does not exist yet, or use the existing table to export data into.

 

Step 7 - Format-specific options - MS Access

 

Password

Specify the database password if you are exporting data to an existing MS Access database which is protected by a password.

 

Table Name

The name of the table within the target MS Access database.

 

Create table if it does not exist

Automatically creates the target table if it does not exist in the target database yet.

 

Export Date/Time fields as nvarchar

Enable the option to convert Date/Time data to nvarchar when exporting.

 

CheckBox Apply to all exported objects

Enable this option to make settings common for all objects.

 

CheckBox Allow captions

Use this option to allow/disallow changing destination fields captions.

 

Use Caption tab to define titles for each of the result fields.

 

Step 7 - Format-specific options - MS Access - Caption

 

All source fields are shown in the Field Name list. Destination captions can be edited in the Caption list.

 

 


See also:

Excel options

Word / RTF options

HTML options

PDF options

TXT options

CSV options

SQL options

XML options

DBF options

Excel 2007/ODS options

Word 2007/ODT options