<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://weblogs.asp.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Uploading an Excel file to SQL through an ASP.NET webform</title><link>http://weblogs.asp.net/rajbk/archive/2009/05/02/uploading-an-excel-file-to-sql-through-an-asp-net-webform.aspx</link><description>The method below describes how to upload a file to a webserver and then import the file into SQL using either LinqToSQL or SQL Bulk Copy. The sample code only shows how to import xls and xlsx files but it could easily be extended to support csv files</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP1 (Build: 20510.895)</generator><item><title>re: Uploading an Excel file to SQL through an ASP.NET webform</title><link>http://weblogs.asp.net/rajbk/archive/2009/05/02/uploading-an-excel-file-to-sql-through-an-asp-net-webform.aspx#7245587</link><pubDate>Tue, 03 Nov 2009 01:48:22 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7245587</guid><dc:creator>rajbk</dc:creator><author>rajbk</author><description>&lt;p&gt;&amp;gt;Microsoft Excel has to be installed in the server to run this code?&lt;/p&gt;
&lt;p&gt;No, but you need 2007 Office System Driver : Data Connectivity Components. I have updated the post with a link to the download.&lt;/p&gt;
&lt;p&gt;Hope that helps,&lt;/p&gt;
&lt;p&gt;Raj&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7245587" width="1" height="1"&gt;</description></item><item><title>re: Uploading an Excel file to SQL through an ASP.NET webform</title><link>http://weblogs.asp.net/rajbk/archive/2009/05/02/uploading-an-excel-file-to-sql-through-an-asp-net-webform.aspx#7245497</link><pubDate>Mon, 02 Nov 2009 22:14:28 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7245497</guid><dc:creator>Daniel Ramos</dc:creator><author>Daniel Ramos</author><description>&lt;p&gt;Microsoft Excel has to be installed in the server to run this code?&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7245497" width="1" height="1"&gt;</description></item><item><title>re: Uploading an Excel file to SQL through an ASP.NET webform</title><link>http://weblogs.asp.net/rajbk/archive/2009/05/02/uploading-an-excel-file-to-sql-through-an-asp-net-webform.aspx#7223919</link><pubDate>Tue, 06 Oct 2009 06:48:41 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7223919</guid><dc:creator>Pradeep</dc:creator><author>Pradeep</author><description>&lt;p&gt;Nice Article, I learned from you article that there can be many consecutive usings for single code block&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7223919" width="1" height="1"&gt;</description></item></channel></rss>