Bulk insert into table using csv file or excel file

bulk insert [ filename ] from '[ filepath ]'
with
(
fieldterminator=',',
rowterminator='\n'
)


Bulk insert from Excel file
-- Method#1
INSERT INTO dbo.ImportTest

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=C:\ImportData.xls;Extended Properties=Excel 8.0')...[Sheet1$]

--Method#2

INSERT INTO dbo.ImportTest

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\ImportData.xls', 'SELECT * FROM [Sheet1$]')