Bulking insert error

  • 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.

  • 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