Exportizer Users' Guide vlsoftware.net

Opening Databases

Contents Index Previous Next

You can open databases in Exportizer by the following ways:

1. Choose 'File | Open Data Source...' menu item or click 'Select Data Source' button . 'Select Data Source' dialog will appear. Choose interface (ADO, BDE, Interbase), select data source (may be a file, folder, ODBC DSN, or connection string) to open, and click OK.

Select Data Source Dialog

Different interfaces have different set of available data source types:
Interbase interface allows to work with files only;
BDE interface can work with files, folders, and ODBC data sources;
ADO interface can work with files, folders, ODBC data sources, and connection strings.

ADO connection strings give you a very customizable alternative or even the only way to open your data source. They can be typed manually (there are a lot of examples in the Internet) or built automatically. The second way is quite simple: specify your data source (file, folder, or ODBC DSN), then click 'Convert to connection strings' button to the right; Exportizer will create a set of available connection strings for the selected data source, and you can select the most suitable one from the corresponding drop-down list in the bottom; you can then add additional connection string parameters (for advanced users). Please note that if your data source is not a file or folder or ODBC DSN (for example, Oracle, MySQL, SQL Server data source), then you should type the connection string manually. Often, one data source can be opened by different connection strings, which may cause your connection will have some different properties.

2. Select needed file or folder in Windows Explorer and drag it into Exportizer main window. If you select folder or more than one interface (ADO, BDE, Interbase) is suitable for opening this database type, 'Open Data Source' dialog will appear; otherwise, Exportizer will open selected file.

3. Some files (e.g. DB or DBF) can be opened using file associations. If such a file was associated with Exportizer when installing the software, it is enough to click it twice and Windows will automatically start Exportizer, and it will open the selected file.

4. You can quickly open the most recently used data sources by selecting them from dropdown list in the right part of 'Select Data Source' button or using 'File | Reopen' menu. When you move mouse over the list, the status line will display some extra information of the data source name below the mouse. You can also open and export all tables from a folder or another multi-table data source at a time by selecting the corresponding items from File menu (available only in Exportizer Pro).

5. All supported file types can be opened also via command line. This way can be used in Windows shortcuts, .bat files, your own programs etc.

After opening (connecting) the specified data source, all tables from it will be shown in the left part of the main window. You can open needed table from the table list by clicking it or selecting it by keyboard means. If the selected database file is a database table (for example, dBase (.DBF) file, file of comma separated values (.CSV) etc.), Exportizer will open its folder as a database and then open that database file as a table.

In Exportizer Pro, it is possible to build and open custom SQL queries. To show SQL editor, click 'SQL Editor' button or select the corresponding item from Query menu. To open an SQL query, type the query text in the SQL editor and then click 'Execute Query' button or select the corresponding item from Query menu.

If selected data source is a multi-table database (for example, ODBC DSN, Microst Access database (.MDB), Microsoft Excel sheet (.XLS) etc.), then only Exportizer Pro can open it.

See also

 Ways of Opening Different Data Source Types

 Connection Strings Examples