Opening a Database

Connect to a database you want to use for the variable data.

You can use databases similar to the following. Specify the file name and connect to the database.

Database Type		Specify the database for connection
Type	Version	Specify the database for connection
Text file	-	Yes (.txt, .csv)
Excel	2003/2007/2010/2013	Yes (.xls, .xlsx, .xlsb, .xlsm)

Specifying the Database after Starting Variable Editor

Select the [Database] menu > [Database Connection/Settings].

The [Database Connection/Settings] dialog box is displayed.

Click [Browse] in [Database Path].

The [Open] dialog box is displayed.

Select the file, and click [Open].

The field that will be used is displayed in the [Database Connection/Settings] dialog box and [Database] in the Object Palette Pane.

The [Database Connection/Settings] dialog box is displayed again.

Click [OK].

Note
When setting an Excel file with multiple sheets as a connection destination, you can select a sheet to use as a database in [Database Table]. Follow the same procedure when changing the database you want to use. To filter the records of the set database, see the following. Setting a Filter for Records

You can specify and open a database when starting Variable Editor. For more information, see the following.

You can disconnect a database that is currently connected.

Select the [Database] menu > [Disconnect Database].

The connected database is disconnected.

Note
By disconnecting the database, placed fields can no longer be previewed. Reconnecting to the database enables you to preview them again.