[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 549
  • Last Modified:

Upload .xls file to SQL Server using ASP.NET

Can somone advise mwe on the simplest way to upload a .xls from a ASP.net website(vb) to a table in SQL server. I used to do it with the classic ASP by ploading the file to a folder and then using DTS in SQL but there must be an easier more effective way.  Thanks
0
Ed
Asked:
Ed
1 Solution
 
santoshmotwaniCommented:
0
 
Valliappan ANSenior Tech ConsultantCommented:
Have a look at these links:

http://weblogs.asp.net/rajbk/archive/2009/05/02/uploading-an-excel-file-to-sql-through-an-asp-net-webform.aspx
(Uploading an Excel file to SQL through an ASP.NET webform)

http://www.davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx
(Import Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy)

http://forums.asp.net/t/1162069.aspx
(How to import Data from Excel to SQL Server Express)

and

http://weblogs.asp.net/scottgu/archive/2006/05/29/Reading_2F00_Writing-Excel-Spreadsheets-with-ADO.NET.aspx

Hope that helps. Thanks.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now