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.
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...
It is a late post, but now there is an ADO.NET way to this - http://support.microsoft.com/kb/316934#12
I have a potential workaround.
I am going to create a CLR stored procedure that will in turn perform a passed SQL query using the managed provider.
I can then invoke the stored procedure using SQLServer OLE DB or ODBC providers.
It should work, if Murphy stays away.
For an Excel formula I need the first cell out of a list of cells which contains a numeric value: A | B | C | ... | Z | ----------------------------- | 0.1 | 0.4 | ... | =0.1 | | ...
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
Does anyone know how to convert an Excel date to a correct Unix timestamp?
I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
I have created an Add-In in C# that implements user defined functions for Excel. These UDF s return immediately, but they control background asynchronous procedures. These procedures have status ...
