Browsing data source tables
The browser is launched by selecting \Tools\Browse table... from the system menu. It looks like a query form. First you will be offered to select one of the data sources, defined in Dataodyssey Express before. Then you will see the data source table list. Select one you need and a query form will appear.
form retrieval condition and retrieve data from a table;
sort retrieved data (double-click any column header);
export data to Excel;
fill a range of an Excel worksheet.
export data to any data source.
The tool is launched by selecting \Tools\Explore table... on the system menu. First you will be offered to select one of the data sources, defined in Dataodyssey Express before. Then you will see the data source table list. Select one you need. The third step is making table fields in a certain order by which an explorer tree will be built.
The explorer will look like this:
When selecting a tree branch the correspondent data will be shown in the right table. The data in the table can:
be exported to Excel;
fill Excel worksheet ranges;
be exported to any data source.
The tool is launched by selecting \Tools\Copy tables... from the system menu. It allows to copy tables from one specified data source into another. The data sources can be of different type. It is possible to copy tables from Microsoft Access to Microsoft SQL Server or ORACLE, DBF tables to MySQL and so on. You can't only copy tables to Microsoft Access, but you can copy from it. Make the tables of an initial data source on the left to be shown on the right and specify a data source to copy the tables in.
It is possible to specify new names for selected tables. This is particularly important when you copy tables with names longer than 30 characters to ORACLE from other data sources. The program will handle this situation.
Dataodyssey Express will try to copy indexes for selection optimization in new source. Not all indexes can be copied from one data source to another. This moment is specially actual for data from MS Access.
We don't offer this mean as universal for tables copying. This just a mean to solve some problems during working with data inside Data Odyssey. But probably this tool can be useful as itself.
The tool is launched by clicking \Tools\Select and ZIP tables... on the system menu. It allows to make a query to tables of any data source and archive query results. Select an initial data source, the tables you need, and specify the name and location for the ZIP file (by the ZIP file button).
it is impossible to store data to a file bigger than 2 Gb;
the file size of a ZIP archive is also limited
DBF tables are archived without confirmation.
Packaging DBF Tables
As is known, no data is removed physically when DBF table records are removed. It makes sense to periodically pack DBF tables. During packing:
the data marked as removed is physically removed;
indices are rebuilt.
The tool is launched by selecting \Tools\Pack DBF tables... from the system menu. Select an initial data source, then the required tables, and click Pack.
Repairing Corrupted DBF Tables
The most common DBF table failure occurs when the number of rows, defined in the table header, does not match with the real number. This happens as a result of system, network or hardware errors, when the records have already been added to a table, but the header couldn't be corrected. Many programs, working with DBF, compare the real number of records with the one declared in header. In case of mismatch the user is warned by the "Not a table!" message and the process terminates.
While packing, Dataodyssey Express will open tables without such verification. An error of that kind will be corrected during packing.