 Re: How to insert data from a csv file into a SQL server database?
Yes...we can insert the data from csv using bulk insert for example
-- insert the data
bulk insert [dbo].[tablename]
from '<<ToDo: add path to sample.csv>>'
with
(
fieldterminator = ',',
rowterminator = '\n'
)
GO |