I have more than 90k Record in my table, I want to Import it to excel and give to client when they click download button from website, I have tried some code which takes too much time or more than 30 min.
I have tried to export record from directly SQL using Stored Procedure but it gives different errors which I have no idea what it is actually because I tried to search a lot.
- Msg 7399, Level 16, State 1, Line 2
- The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
- Msg 7303, Level 16, State 1, Line 2
- Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
Basically, I want to know what is the best way to import and export from SQL to excel when data is more than 1lc Record.
I am Using C# Web API With Angular And Sql 2012