ARTICLE

Import Data from Excel to a SQL Server database

Posted by vivekananda swamy in Articles | ADO.NET in C# on January 16, 2009

Tags: Import Excel to SQlServer, Reading null values from excel sheet, Replacing the excel sheet null values with zeros and storing them in the SqlServer

This article mainly describes about how to import the data from Excel sheet to the SQL Server database.

Tweet
20961
22

Reader Level: Intermediate

Download Files:

ImportExcel2SQLServer.zip

This article mainly describes about how to import the data from Excel sheet to a SQL Server database.

Download the attached project and run in Visual Studio 2005.

The application uses a GridView control to dusplay, delete, and save data. If an Excel sheet does not have any data (null values), those values are stored as zeros in the database.

Explore the source code for more details and post a comment below if you have any questions or comments.

post comment

File is corrupted

Posted by Suthish Nair on Jan 31, 2011

Can you please guide me to export csv filt to sql server 2005?

For your information ImportExcel2SQLServer.zip file is corrupted it seems. Can you please send me the full solution file?
This is my email : vskhannan@hotmail.com

Thanks, Kannan S

Posted by kumar S on Oct 07, 2010

Hi Vivek,

While searching a solution for Import Excel to SQL,i got yours. Is it possible for you to share the code. Appreciate your help. Pls forward the source code to shiv_dsnair@yahoo.co.in

Thanks in Advance,
shiva

Posted by shiva on Jun 18, 2010

hello sir pl z help me
how to import csv excel sheet data in sql server where tables in relations?

Posted by vicky logic on Jun 17, 2010

thanx alot dear it really help me......

Posted by vicky logic on Jun 17, 2010

View All

TOP LEADERS

View All

TRENDING UP

Learn MVC (Model view controller) Step by Step in 7 days – Day 3 Learn C# Corner - Home Using Border Radius and Gradients in CSS3: Part I Learn C# Corner - Footer Learn .NET and C# in 60 Days Lab13(Day 5): - Classes and objects iPhone 5 First Look Samsung Galaxy Note Review WCF - Authentication and Authorization in Enterprise Architecting How to write a good article on C# Corner How to Display Data in ListBox From SQL Database in ASP.NET

View All

Sponsored by

Become a Sponsor

MOST LIKED ARTICLE

Learn .NET in 60 days – Part 1 (13 Labs) Working with ProgressBar in C# Resizable TextBox in ASP.NET using AjaxControlToolKit Word Processing with an Extended Rich Text Box Control Notepad in C#

PREMIUM SPONSORS

Dynamic PDF

ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications.

ASP.NET 4 Hosting

Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites - Click Here!

LATEST JOBS

Applying for job Metro Style App Developer .NET Developer WPF or Silverlight exp Boston MA ASP .Net Developers Split Testing Designer .NET Developer Web Developer Application Engineer Expert .NET Developer Application Developer

View All Jobs |Post a New Job

Import Data from Excel to a SQL Server database

Related Articles