Quote:
Originally Posted by kingmaker  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 |
Hi,
Can we able to import data from Excel / Text (Tab Delimited) file into SQL server ?
What are all the file types SQL server supports for import data ?