Select an Origin Database
There are two ways in which you can select the origin database:
• Manually enter the path to the origin database in the Selection field; or
• Click the Select button to browse to the location of the origin database.
Locate the Origin Database By Entering the Path
If you choose to manually enter the path, you must use the full path to the origin database, including the drive letter, and the extension of the origin database (e.g. "C:\\Database Files\My Origin Database.xls").
Note: The path is not case sensitive, however, you must correctly enter spaces in directory names and database file names where they appear.
Once you have correctly entered the full path to the origin database, press the Enter key. The Database Conversion Utility will search for the origin database.
Locate the Origin Database Using the Select Button
If you prefer to locate the origin database by browsing your directory structure, you may use the Select button to do so.
Click the Select button in the Origin section of the Database Conversion Utility. The Select Origin Database File dialog opens. Use this dialog to browse to the location of the origin database.
Note: The Files of Type drop-down list that appears at the bottom of the Select Origin Database File dialog is configured to display Access Databases by default. Change the selection of the Files of Type drop-down list to "Excel Files" or "All Files" if the origin database is not an Access database.
Once you have located the origin database, click the Open button. The full path to the origin database will automatically appear in the Selection field in the Origin area of the Database Conversion Utility, along with information about the selected origin database.
Determine the Status of the Origin Database
Once you've located the origin database using either the manual path entry or browse methods described above, the Origin area and the ODBC Status Report areas will display information about the origin database. An example is shown below.
In this example, the database file type is identified to the left of the Select button in the Origin section (in this example, the origin database is an "XLS File"), while the status of the search is identified to the right (in this example, the origin database file is "Found".)
The Status section beneath the Origin section provides statistics on the number of tables and records in the origin database file. As you can see from the example above, there is one tag table, and one "other" table for a total of 2 tables in the origin database. There are 7 records in the tag table and no records in the "other" table for a total of 7 records.
The ODBC Status Report section of the Database Conversion Utility displays information about the scan of the origin database including the SQL command or query performed, and any error code. The error code appears at the bottom of the scrollable ODBC Status Report list. If an error has occurred, the error code and an error state and message will be displayed.
Note: If the origin database was not located, no status report will be displayed in the ODBC Status Report area.