CData ADO.NET Provider for Excel

This .NET Framework Class Library is provided by CData. The main functionality of the class library is contained in the file System.Data.CData.Excel.dll.

Add a reference to the assembly System.Data.CData.Excel and include the System.Data.CData.Excel namespace. Instantiate a new ExcelConnection connection object. Set the connection string and open the connection.

VB.NET code sample

Imports System.Data.CData.Excel
Dim myConnection As ExcelConnection = New ExcelConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()

C# code sample

using System.Data.CData.Excel;
ExcelConnection myConnection = new ExcelConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();

Description

The CData ADO.NET Provider for Excel abstracts the underlying data source into tables, views, and stored procedures that can be used to both retrieve and update data.

An important feature of the CData ADO.NET Provider for Excel is the ability to easily cache data locally. This allows the CData ADO.NET Provider for Excel to be used in an offline mode when access to the data source is not possible. It also enables complex SQL queries which otherwise are not supported by the underlying data source itself.

This provider was formerly named "RSSBus ADO.NET Provider for Excel"

More info about this class library can be found at the CData product page.

Download

This .NET Framework Class Library, CData ADO.NET Provider for Excel, can be downloaded here.

Connection Strings

The CData ADO.NET Provider for Excel class library can be used to connect to the following data sources by using the following connection string references:

ExcelExcel 97Excel 2000Excel 2002Excel 2003Excel 2007Excel 2010Excel 2013