DB Vue allows users to easily search tables and fields in databases and
to browse and export data to Excel.
It is designed to save time and money, it is easy to use and
preserves user's options for the next time it runs.
Features and Benefits
- Compatible with Oracle and Access
databases.
- Filter tables by name
- Search for a field by name in all tables
- List all fields and their properties in each table
- Show tables by type
- Copy fields to Excel or to other applications
- Browse through the records of the tables
- Copy data to Excel or to other applications
- Export complete tables or selected columns from databases to Excel
- Settings are saved between sessions
Usage
-Start the application by browsing the
menu: All Programs, Office Optimum, DB Vue. -Enter the database information:
-For Oracle enter the data source name,
user ID and password in the Oracle tab then
click Browse.
-For Access click the
Select Access button to select an MDB file
in the Access tab. Enter the user ID and
password, if required by the database, then click the Browse
button.
All the available tables will be listed in
the Tables grid.
-You can use the Show option buttons to view only certain
types of tables.
-Filter the tables by entering a table
name or part of its name in the
Filter Table Name box. -Search for a column by name
in all tables by entering a column name
or part of its name in the Column Name
Search box
provided and clicking the Search button.
-Click the Browse
button again to refresh the list of tables.
-Double click a table name or its row
in the Tables grid to list all
columns and data in that table.
-The rows of data listed are limited by default in this application to 100 rows. You can
change this value in the Settings menu.
Increasing this value will reduce the
application response time.
-To copy any data from the grid select one or more cells or a complete row, then press Ctrl + C
keys.
-Sort data by clicking on the column header. Click again to sort in reverse order.
-To export data from the current table to Excel, first select columns you wish to export by double clicking column headers or leave all columns unselected to export them all. Then, click the Export to Excel button.
-For security reason the passwords are not saved between
sessions.
-Also, this application does not change
any data or otherwise alter any
database.
Home
AutoCAD Tools
