Databases can be opened by the following ways:

Using Register Database dialog

Use Select Data Source button  or the corresponding item from the File menu. In this dialog, you choose all parameters you need to open the database, and register the database for future use.

Opening files directly from Windows Explorer

Some files (for example, DB, DBF etc.) can be opened by using file associations. If such a file is associated with Exportizer, then it is enough to click it twice and Windows will automatically start the associated program, and it will open the selected file.

Also, you can drag files from Explorer and drop them into the open instance of Exportizer.

Opening databases from command line

Almost all supported database types can be opened from the command line.

Opening files, which are not database files

Besides databases, Exportizer Pro and Exportizer Enterprise can also open some other file types:

Action files. These files can be opened and executed using the corresponding tab of Register Database dialog or from the command line.

SQL files. When opening .SQL files, the program firstly opens a folder, which contains the file (see above), then loads text of the file into SQL editor. Sometimes, before opening such file, Exportizer Pro/Exportizer Enterprise lets you select associated database through Register Database dialog.

When opening files of other types, Exportizer in most cases will try to open them like it does for database files (see above).

Reopening previously opened databases

The most recently used (MRU) databases can be accessed from File | Reopen or File | Registered Databases... menu, and can be easily reopened from there.

Some databases require password to be open. You can optionally save the password after successful database opening to avoid typing the password in the future. All saved passwords can be removed by choosing File | Registered Databases... | Clear Passwords.

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

In the context menu of the Exportizer Enterprise table list, there is an option to open the table in Live Data Window mode, which allows to scroll down and export huge database tables without memory overflow. But this mode increases the database workload and slows down performance. It is recommended to use this option only when you cannot export a huge table due to memory errors. This option works for FD connections only. You can use it only for tables with primary key and cannot use for custom SQL queries.

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 and Exportizer Enterprise, 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, Microsoft Access database (.MDB, .ACCDB), Microsoft Excel sheet (.XLS, .XLSX), Oracle database, SQL Server database, etc.), then only Exportizer Pro and/or Exportizer Enterprise can open it.

See also

 Ways of Opening Different Data Source Types

 Connection Strings Examples