mssql bulk insert not working while executing from php

Question

I have the following bulk insert script

$sql="BULK
                INSERT nibble
                FROM 'd:\nibble.csv'
                WITH
                (
                FIELDTERMINATOR = ',',
                ROWTERMINATOR = '\n',
                FIRSTROW=2
                )

                ";
mssql_query($sql);

Msg 4860, Level 16, State 1, Line 1 Cannot bulk load. The file "d:ibble.csv" does not exist.

but when i execute from sql below server management studio it works .. what is the issue

BULK
                INSERT nibble
                FROM 'd:\nibble.csv'
                WITH
                (
                FIELDTERMINATOR = ',',
                ROWTERMINATOR = '\n',
                FIRSTROW=2
                )

Shankar Narayana Damodaran · Accepted Answer · 2014-01-26 07:16:49Z

1

You need to escape the backslash with another backslash. From d:\nibble.csv to d:\\nibble.csv

Do this way..

<?php
$sql="BULK
                INSERT nibble
                FROM 'd:\\nibble.csv'
                WITH
                (
                FIELDTERMINATOR = ',',
                ROWTERMINATOR = '\n',
                FIRSTROW=2
                )

                ";
mssql_query($sql);

answered Jan 26, 2014 at 7:16

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mssql bulk insert not working while executing from php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related