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).


  1. Consider using correct Database Tour architecture (32-bit or 64-bit) when interacting with third-party database components (ODBC drivers, OLE DB providers, client-server software etc).
  2. For all cases, where ADO or BDE is mentioned, the ADO 2.1+ and BDE 5+ must be installed, respectively.
  3. 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.
  4. 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)

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 Server


SQL Anywhere (Adaptive Server Anywhere)




Pervasive PSQL





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

 Examples of ADO Connection Strings

 Opening Data Source