Creating a custom ODBC / OLE driver in C#

Question

Does anyone know how to create an ODBC or OLE driver preferably in C#?

What I want to do is creating a custom data source which I can use in Excel and Access. Or do think of another way how to do this?

Thanks in advance for your responses!

Answer 1

There is a simplified version of OLE DB Driver in C#. In the article below, the sample provides an access to in-memory array.

This is a good starting point in C#.

http://exceldevelopmentplatform.blogspot.com/2018/10/oledb-simple-provider-c-custom.html