October 10, 2018 at 5:07 am
Hello everyone!
I am new to the forum and I am currently struggling with a bulk insert error.
The thing is that I want to import bulk data into the server table but it keeps failing into the error mentioned below, I have already tried using .txt and .csv files, but no success on those two.
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 am really kinda lost with this issue and is driviing me crazy, probably its just a simple task to resolve, but as I already said I am clueless, maybe due to me being still a newbie.
Could you please have a look and try to enlight me with your responses?
Thank you so much in advance.
Consultoría de redes de comunicaciones industriales y domésticas.
October 10, 2018 at 5:33 am
Does that file path exist on the server, or on your local machine?
Here's a quote from the online documentation (the emboldening is mine):
data_file must specify a valid path from the server on which SQL Server is running. If data_filedata_file is a remote file, specify the Universal Naming Convention (UNC) name. A UNC name has the form \\SystemnameSystemname\ShareNameShareName\PathPath\FileNameFileName. For example,
\\SystemX\DiskZ\Sales\update.txt
\\SystemX\DiskZ\Sales\update.txt.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply