Reader Level:
ARTICLE

Import Data from Excel to a SQL Server database

Posted by Vivekananda Swamy Articles | ADO.NET January 16, 2009
This article mainly describes about how to import the data from Excel sheet to the SQL Server database.
  • 0
  • 0
  • 32376
Download Files:
 

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.

COMMENT USING

Trending up