New answers tagged export
Instead of exporting from SharePoint, you can try importing from Excel through add-ins like http://www.cdata.com/drivers/sharepoint/excel/ (commercial). The Excel Add-in allows you to connect to Sharepoint lists, and filter data through transact SQL.
if you are working with Sharepoint2013 than 2013 provide out of the box service to export sharepoint list to Exel or Access. I have refer This one , you can also try it . https://www.microsoftpressstore.com/articles/article.aspx?p=2224034&seqNum=2
Top 50 recent answers are included