I m trying to insert a .csv file to a table
i have saved my file in the c drive root
this is the code:
BULK
INSERT [XX].[dbo].[abc]
FROM 'E:\abc.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
)
GO
and this is the error
Msg 4860, Level 16, State 1, Line 1
Cannot bulk load. The file "C:\abc.csv" does not exist.
but the file is nicely in the path, can some one help me to solve this
thanx