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.
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
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 Reportizer 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 databases (.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)
XML files (.xml)
SQL Anywhere (Adaptive Server Anywhere)
Reportizer 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.
Examples of ADO Connection Strings
Report Data Sources