title: How to create a data provider for use with Excel
body: <p>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? </p>