Database Conversion Utility

The Database Conversion Utility allows you to convert ODBC compliant databases from one format to another. It does so by reading the table and record information from the origin database and writing that information to the destination database. Currently, the Database Conversion Utility supports conversion of Excel spreadsheets (*.XLS) and Microsoft Access (*.MDB) database files.

An image of the Database Conversion Utility is displayed below.

As shown in the above image, the Database Conversion Utility consists of three sections from left to right:

•      Origin – The Origin section enables you to select the origin database from which the data will be converted. It also displays statistics concerning the contents of the origin database, including the number of tables and records that exist within it;

•      Destination – The Destination section enables you to select the destination database to which the data will be converted. It also displays statistics concerning the contents of the destination database, including the number of tables and records that exist within it;

•      ODBC Status Report – The ODBC Status Report section displays information about the scan of the origin database and the scan of the destination database, including the SQL command or query performed, and any error codes, states and messages if any were encountered during each scan. This information is displayed separately following each scan you perform.

As indicated by the right-facing arrow, the flow of conversion is always from the origin database to the destination database (left to right).

Beneath the ODBC Status Report appears a Convert button. This button converts the data found in the origin database to the destination database. Once the conversion and transfer of data is complete, information is displayed in the ODBC Status Report scrollable list.

If you require more detailed information on using the ODBC Database Conversion Utility, step-by-step instructions can be found in the "VTS Developer's Guide: 7: Databases and Data Sharing: ODBC Browser Utility".