Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 external data source extend table refresh | Excel Discussion (Misc queries) | |||
EXCEL: OLE DB provider for OLAP Services 8.0 Missing | Excel Programming | |||
OLE DB Provider and Excel | Excel Programming | |||
Excel schema using Jet OLEDB Provider? | Excel Programming | |||
Connectiong to an Excel Workbook with MSDASQL provider | Excel Programming |