CODEWITHSUNDEEP
c#databaseexcellinq-to-entities
456qwe123asd
456qwe123asd

Reputation: 191

import and export excel file (csv, xls and xlsx) from database by linq

Does someone know how to export an excel file (csv, xls and xlsx) from database (sql server 2008). Better is using linq to entity and c#.net.

furthermore, I also need retrieve back the excel file (csv, xls and xlsx) and store into database as well.

It is better if not using third party source.

Currently I'm using Visual Studio 2010.

Upvotes: 1

Views: 2572

Answers (2)

CloudyMarble
CloudyMarble

Reputation: 37576

But you can use the SQL Server itself to export to Excell. watch this video

Upvotes: 1

Brijesh Mishra
Brijesh Mishra

Reputation: 2748

better use library like epPlus http://epplus.codeplex.com/

Upvotes: 1

Related Questions