This topic describes ways of opening different types of data sources using Open Data Source dialog, and contains important notes you should know to do this right.
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).
Notes
- Consider using correct Database Tour architecture (32-bit or 64-bit) when interacting with third-party database components (ODBC drivers, OLEDB providers, client-server software etc).
- 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 Database Tour 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)
Interbase databases (.gdb, .ib)
Visual FoxPro databases (.dbc)
Text and CSV files (.txt, .csv)
SQL Anywhere (Adaptive Server Anywhere)
Database Tour 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.
See also
