How do I use an ADO.NET managed provider in Excel?

Question

I have an ADO.NET Managed Data Provider that is registered in machine.config in DbProviderFactory - It is available for use from, say, Analysis Services, so I know it is correctly registered.

However, I need to be able to query the managed provider from Excel, but the managed provider doesn't appear as a choice from Data Link Properties | All Ole Db Providers.

How do I get an ADO.NET Managed Data Provider to appear there, or is there another technique I need to use?

Thanks in advance, Eli.

Answer 1

Turns out there is no way to directly use an ADO.NET provider in Excel.

Had to write an OLE DB provider (in ATL C++ no less) to bridge the two - that was fun...

Answer 2

It is a late post, but now there is an ADO.NET way to this - http://support.microsoft.com/kb/316934#12