Ways of Opening Different Data Source Types

Here is described ways of opening different types of data sources using Open Data Source dialog, and important notes you should know when doing this.

If you cannot find the type of your data source here, you still may try to open it using description of similar data source type, using ODBC (if ODBC driver for your data source type exists), or using your own connection string (there are lot of connection strings' examples in the Internet).

For all cases, where ADO or BDE is mentioned, the ADO 2.1+ and BDE 5+ must be installed, respectively.

For all cases, where connection string is mentioned, please ensure that provider used in your connection string is installed and ODBC driver (if the connection string is ODBC based) is also installed.

When you build connection strings, please take into consideration that Exportizer Enterprise can work with OLE DB based and ODBC based connection strings. Other types (.NET etc.) are not prohibited, but the result of using them is unknown.

Microsoft Access databases (.mdb)

Microsoft Access 2007+ databases (.accdb)

Microsoft Excel workbooks (.xls)

Microsoft Excel 2007+ workbooks (.xlsx, .xlsb, .xlsm)

HTML files (.htm, .html)

Firebird databases (.fdb)

Interbase (.gdb, .ib)

UDL files (.udl)

dBase files (.dbf)

FoxPro files (.dbf)

Visual FoxPro databases (.dbc)

Paradox files (.db)

Text and CSV files (.txt, .csv)

Lotus files (.wj2, .wk1)

SQL Anywhere (Adaptive Server Anywhere)

Exportizer can also open other types of databases, if the corresponding OLE DB provider or ODBC driver has been installed on your computer. You just need to build the connection string using examples from the internet.