-
Dec23
import excel to sql server 2005/2008
Filed under: MSSQL - SERVER;No Commentssave you excel in csv.
Bulk
INSERT elect
FROM ‘c:\data\file2.csv’
WITH
(
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)
GO
–Check the content of the table.
SELECT *
FROM elect
GOelect isĀ your table name and c:\data\file2.csv is your csv file path.
Nishant
