shaikwaseem888 - Saturday, December 30, 2017 3:24 PM

Dear Friends,

i am new in this forum and i hope that i will get the solution to this error.

actually, i want to import bulk data into the server table but literally failing below of the error mentioned below, i have tried both the ways using .txt and .csv files but still fails.

Cannot bulk load because the file "‪C:\Users\Shaik\Desktop\Import.csv" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).

BULK INSERT PhoneBook
FROM '‪C:\Users\Shaik\Desktop\Import.csv'
WITH

(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

i dont know how to solve it, Please have a look a try to give me your responses.

Thanks