Databases (or spreadsheets) supporting OleDB interface

  • Name: OleDB
  • Version: 1.0.0.0
  • Protocol: OleDB
  • Interface: TCP/IP
  • Runtime: .NET 2.0 (Multiplatform)
  • Configuration:
    • Datasets / DBs

Overview

This section will connect with Excel files using OleDB

OleDB

OleDB enables higher abstraction and flexibility when connecting to data sources, supporting a more comprehensive range of data access technologies and file formats. To connect using this method, follow the steps below:

  1. Access Datasets / DBs and click the plus icon.
  2. Select ODBC Data Provider as Provider and choose the Microsoft Excel Database as Database.
  3. Click OK.
  4. After returning to the data grid, click the Connection String column related to the newly created row.
  5. Enter the path and the name of the Excel (.xls) file to be used as the database in the Data Source field. 

In this section...