Origin Section of the Database Conversion Utility

The Origin section allows you to select an origin database from which data will be converted to the destination database specified in the Destination section.

The Origin section is divided into two smaller sub-sections:

Selection; and

Status.

These sections are described in detail below.

Selection Sub-section of the Origin Section of the Database Conversion Utility

The Selection sub-section of the Origin section of the Database Conversion Utility consists of the Selection field, the Select button, and an indication of the type of database file that has been selected as the origin database. You may use the Select button to browse to the origin database of your choice, or you may choose to manually enter the path to the origin database in the Selection field.

Once you've specified the origin database, the type of database you've chosen will be displayed to the left of the Select button (e.g. "XLS File" or "MDB File"). If you have selected a non-compatible or unknown database type, "No Match" will be displayed.

To the right of the "Select" button is an indication of the availability of the selected file. This area will display "Found" if the origin database was successfully located and read, or "Not Found" if the selected origin database file was not located. The origin database file must be found in order to perform conversions.

Status Sub-section of the Origin Section of the Database Conversion Utility

The Status sub-section of the Origin section of the Database Conversion Utility displays statistics on the number of tables and records located in the origin database file, along with a status indication which may be one of the following:

•      [Unknown] – If the status indication reads "Unknown", there is no database file selected, or it was not found;

•      [Creating] – If the status indication reads "Creating", a data source for the database is being created;

•      [Connecting] – If the status indication reads "Connecting", a connection to the database is being established;

•      [Error] – If the status indication reads "Error", a connection to the database could not be established;

•      [Scanning] – If the status indication reads "Scanning", the database is in the process of being scanned;

•      [Scanned] – If the status indication reads "Scanned", the database has been successfully scanned;

•      [Reading] – If the status indication reads "Reading", the database is in the process of being read; or

•      [Read] – If the status indication reads "Read", the database table and record information has been read from the origin database.

ODBC Status Report Following a Scan of the Origin Database

Following a scan of the origin database, the ODBC Status Report area will provide information on the Origin Database Scan Results, including data such as:

•      The path of the origin database;

•      The SQL queries used to access the data in each of the database tables; and

•      Any reported error codes, the status of the error, and a message defining the cause of the error.