Databases can be opened by the following ways:

Using Open Data Source 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 or Exportizer Pro, 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 or Exportizer Pro.

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 can also open some other file types:

Action files. These files can be opened and executed using the corresponding tab of Select Data Source dialog or from the command line.

SQL files. When opening .SQL files, Exportizer Pro firstly opens folder, which contains the file (see above), then loads text of the file into SQL editor. Sometimes, before opening such file, Exportizer Pro lets you select associated database through Select Data Source 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. 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, Microsoft Access database (.MDB, .ACCDB), Microsoft Excel sheet (.XLS, .XLSX), Oracle database, SQL Server database, etc.), then only Exportizer Pro can open it.

See also

 Ways of Opening Different Data Source Types

 Connection Strings Examples