ASP.NET Import from Excel to SQL Server

Question

User-587630019 posted

What's a good recommendation for an ASPl.NET import process from Excel to SQL Server using C#?

It needs to include the following functions:

- Select .xls or .xlsx file from user's local disk drive

- Select sheet within the Excel file

- Select with or without header row

- Preview selected data in a Gridview

- Import

Answer 1

User970350993 posted

Hi

check this link.

http://forums.asp.net/t/1644001.aspx

Answer 2

User-589637085 posted

http://support.microsoft.com/kb/306397

step by step instructions. just remember that your excel file must have (.xls) extension

Answer 3

User-587630019 posted

I'm looking for an ASP.NET C# solution, not SQL Linked Server. 

Answer 4

User-589637085 posted

If you are using Client's data file, then you will have to upload that file to your application.

I have seen code on google creating .xls file.  In your case you have to read .xls (you will get the idea by looking at code).

Also, is it safe to upload data from client to sql (what if client sends garbage/script and large data files)?