Reader Level:

Import Data from Excel to a SQL Server database

By Vivekananda Swamy on Jan 16, 2009
This article mainly describes about how to import the data from Excel sheet to the SQL Server database.

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.

Vivekananda Swamy
Vivekananda Swamy

Hi I am M.Vivekananda Swamy, from Hyderabad.I have completed my Master's In Computer Applications from Osmania University.currently working as an Software Engineer in Hyderabad.I have about 4.7+ yr experience in dealing ... Read more