CUSTOM OLE DB PROVIDER FOR EXCEL

Implement a custom OLE DB Provider in C++ which will read data from a CLR library implemented in C#. The custom provider will only be used to read data from the C# library (this library is a managed provider that will expose the data through the IDataReader interface); the provider will only be used as wrapper to make the data available to excel. The provider will be similar to the example provider in this article [login to view URL] except that instead of reading from a text file it will read from the C# library. The provider is not complex, the VS ATL OLE DB Provider Wizard will provide you with a fully functional provider in minutes, all you'll need to do is interface the C# library to read the data; again it's read-only hence only the basic functionality is required.