CData Access ADO.NET Provider v19.0.7216

Easily connect Microsoft Access with BI, ETL, Reporting, and Custom Apps. The Access ADO.NET Data Provider enables user to easily connect to Access data from .NET applications. Rapidly create and deploy powerful .NET applications that integrate with Microsoft Acces databases.

Connect to live Microsoft Access data, for real-time data access
Seamless integration with leading BI, reporting, and ETL tools and with custom applications
Full support for data aggregation and complex JOINs in SQL queries
Generate table schema automatically based on existing Microsoft Access data or manually for greater control of the content you need

DataBind to Access using standard Visual Studio wizards.
Supports ADO.NET Entity Framework (EF 5 & 6), LINQ to Datasets, etc.
Full Unicode support for data, parameter, & metadata.
Support for 32-bit and 64-bit operating systems.
100% Fully-managed NET for .NET Standard, .NET Core, & Xamarin.

BI, ETL, & Reporting Tool Integration
ADO.NET is a popular interface for connecting .NET-based applications with data. Popular BI, Reporting, ETL, Database, and Analytics tools leverage ADO.NET extensibility to provide access to external data, including:

Denodo LINQPad PowerBuilder SAP Crystal Reports SQL Server Analysis Services SQL Server Reporting Services SQL Server Integration Services

Standard ADO.NET Access to Access
The Access ADO.NET Provider offers the most natural way to access Access data from any .NET application. Simply use Access Data Provider objects to connect and access data just as you would access any traditional database. You will be able to use the Access Data Provider through Visual Studio Server Explorer, in code through familiar classes, and in data controls like DataGridView, GridView, DataSet, etc.

The CData ADO.NET Provider for Access hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Working with DataAdapters, DataSets, DataTables, etc.
The Access Data Provider has the same ADO.NET architecture as the native .NET data providers for SQL Server and OLEDB, including: AccessConnection, AccessCommand, AccessDataAdapter, AccessDataReader, AccessDataSource, AccessParameter, etc. Because of this you can now access Access data in an easy, familiar way.

Access ADO.NET Provider Resources:
Take a look at some of our most popular articles from our knowledge base:

Visualize Access in TIBCO Spotfire through ADO.NET
Access Access with Entity Framework 6
LINQ to Access
DataBind Access to the DevExpress Data Grid