Here is described ways of opening different
types of data sources using Open Data Source dialog,
and important notes you should know to do this.
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
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)
Interbase, Firebird databases (.gdb, .ib, .fdb)
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)
XML files (.xml)
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.