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
25358
0

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.

This Feature is Sponsored By

DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.

comments

COMMENT USING

PREMIUM SPONSORS

Infragistics

Infragistics is experts in technology and design, and passionate about helping you build highly performant and stylish applications that solve problems, deliver inspiration, and maximize results.

TRENDING UP

Simple Tooltip Using HTML and CSS Kolkata Chapter Developer Day Official Recap Object Oriented Programming Using C#: Part 9 JsAction with T4 Template Learn OOP Interface Using C# Logging Using Log4net in Compact Framework 2.0 in Visual Studio 2008 S.O.L.I.D Principle Inversion of Control and Resolution With Dependency Injection How To Find A Doctor Near Your Home in SQL Server Creating Simple MVVM Application With Data Binding How to Add an Alias (CNAME) Resource Record to a Zone

View All

MOST LIKED ARTICLE

WCF Introduction and Contracts - Day 1 Create SSRS Report Using Report Wizard CREATE READ UPDATE and DELETE - CRUD Operation Using LINQ to SQL WCF - Data Contract - Day 4 Factory Design Pattern

Follow @twitterapi

SPONSORED BY

Download Your Free HTML5/jQuery Grid Now!

Make Your Data Do More with the Ignite UI Grid. Launch eye-popping, performance-driven HTML5 apps w/ Ignite UI's free jQuery Grid.

WHITEPAPERS AND BOOKS

Interview Questions on SharePoint 2013 SharePoint 2010 Administration & Development Getting Started with Managed Metadata Service in SharePoint 2010 Windows Phone 7 Hileleri Windows Phone Development Step by Step Tutorial Essentials of SharePoint 2010: Business Intelligence Capabilities Working with Directories in C# FileInfo in C# Programming List with C# Source Code: Graphics Programming with GDI+

View All

Poll Result All Polls


Speed of C# Corner

How do you find speed of C# Corner when visiting the site?

Very Fast OK Slow Very Slow

Options	Votes	%
Very Fast	5	8.33
OK	47	78.33
Slow	5	8.33
Very Slow	3	5.00
Total	60	100%

In Focus

Import Data from Excel to a SQL Server database

Related Articles