Bulk Import And Export

Question

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