Retrieve Excel sheet by SQL

Question

Is it possible to retrieve Excel sheets data through C# if it is then is it possible to retrieve the pivot tables information? I am new to C#. Thanks.

Frankie Yu · Answer

Thank you at first. Actually my expectation is to grep the pivot table cache and import it to SQL table. That's what I try to achieve. But awaiting .....

Isaac · Answer

You can set up an ODBC data connection to an excel spreadsheet. This will essentially treat excel as a database each worksheet becoming a table. Then you can connect to the table using c# and sql. There are a few limitations though. You won't be able to create stored procedures or do outer joins. There are probably others too but those are the most frusterating ones I have run into.