How to extend Excel with custom data provider?
 

Hello!
I have written a custom ADO.NET data provider. When the user clicks the
button for importing data, I want my provider to display in the list of
providers. But I don't see how that is being done inside Excel, or any other
Office application.

Is this possible using my ADO.NET provider or do I have to write a OLEDB
provider?


Best regards,
Vemund Haga

How to extend Excel with custom data provider?
 

The unmanaged world of Excel and VBA knows nothing about NET, so I
don't think you can use a NET provider in VBA. Depending on your
needs, you could create a code-behind workbook or a NET add-in using
Visual Studio Tools For Office (VSTO), but if you don't want to do
that, I think you'll have to create an OLEDB provider.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 12 Feb 2009 06:41:00 -0800, Vemund Haga <Vemund
wrote:

Hello!
I have written a custom ADO.NET data provider. When the user clicks the
button for importing data, I want my provider to display in the list of
providers. But I don't see how that is being done inside Excel, or any other
Office application.

Is this possible using my ADO.NET provider or do I have to write a OLEDB
provider?


Best regards,
Vemund Haga

How to extend Excel with custom data provider?
 

Many thanks for your answer. I forgot that .NET hasn't conquered all the
world :-)

\\Vemund

"Chip Pearson" wrote:

The unmanaged world of Excel and VBA knows nothing about NET, so I
don't think you can use a NET provider in VBA. Depending on your
needs, you could create a code-behind workbook or a NET add-in using
Visual Studio Tools For Office (VSTO), but if you don't want to do
that, I think you'll have to create an OLEDB provider.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 12 Feb 2009 06:41:00 -0800, Vemund Haga <Vemund
wrote:

Hello!
I have written a custom ADO.NET data provider. When the user clicks the
button for importing data, I want my provider to display in the list of
providers. But I don't see how that is being done inside Excel, or any other
Office application.

Is this possible using my ADO.NET provider or do I have to write a OLEDB
provider?


Best regards,
Vemund Haga