Versions Compared

Old Version 4

changes.mady.by.user admin

Saved on

compared with

New Version 5

changes.mady.by.user admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page properties
hiddentrue
idconnector-metadata


Property

Value

Sector

Historian & Databases

Group

Database Providers

Connector

OleDB Provider

Name

OleDB



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

On This Page:

Table of Contents
maxLevel2
minLevel2
stylenone

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:

Page Tree
root@parent
spacesV10