Take the 2-minute tour ×

Excel (2010) has functionality to create pivot tables from an external data source like from Access, From Web and other data sources like SQL server and ODBC. Suppose I have created a new database system called X and I want to create the functionality that Excel can connect to this X using a data provider (not an Excel Add-in). What do I develop and where do I start?

share|improve this question
Question is constructive. There are only few valid answers to it. –  jgauffin Dec 13 '11 at 14:35
add comment

closed as not constructive by casperOne Dec 12 '11 at 17:59


1 Answer

up vote 1 down vote accepted

Excel can use any ADO.NET driver If I'm not mistaken. So all you need to do is to follow the following guide. Here is a more detailed description from MSDN Magazine.

You'll need to create an OleDb driver if Excel doesn't support ADO.NET drivers.

share|improve this answer
add comment
