Import ExelSheetData into SqlServer2005 Table

[lrsalunkhe]

Respected How we Import ExcelSheetData into SqlServer2005 Table,by using Asp.net with C# . Thanks.

[Morgs Morgan]

Rather convert your file into .csv(comma delimeted file) and use bulk insert like:

USE your_database_name
Go

BULK INSERT [your_table_name]
FROM 'C:\FolderName\FileName.csv'
WITH
(
FIELDTERMINATOR=',',--this means that your fields(columns) are separated by commas
ROWTERMINATOR = '\n'--and it says that new line is a row terminator
)
GO

From Excel, go File > Save As > Save As file type, look for csv Good luck.