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