Cannot do BULK INSERT

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

I'm new to SQL Server, just started. I am trying to do a BULK INSERT but it keeps giving the error -

Command is -

SQL

BULK INSERT Astronomy_DB.dbo.Messier_Table
FROM 'f:\testdata.cvs'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

but it always gives me the error no matter where I put the file:

Msg 4860, Level 16, State 1, Line 1
Cannot bulk load. The file "f:\testdata.cvs" does not exist.

Could someone please give me a clue?

Posted 17-Sep-15 13:53pm

Member 11298827

Add a Solution

Comments

PIEBALDconsult 17-Sep-15 20:32pm

If SQL Server can't give you a clue then neither can we.

3 solutions

Solution 2

Dave, thank you for the reply. It was actually not a network drive issue - f: was a usb thumb drive I was using. Apparently SQL Server did not like the .csv file extension. I changed it to .dat and had success. the only other problem was the extra commas that Excel put at the each line when I saved as .csv. When I removed those all was well!

Again, thanks for the response.

Posted 17-Sep-15 17:12pm

Member 11298827

Solution 3

Your login should have access to read file on the F drive. Trying moving the file to an alternate drive.

There can be alternates to bulk upload (SqlBulkCopy etc.). Handling BULK Data insert from CSV to SQL Server[^] mentions some of these other approaches.

Posted 17-Sep-15 17:15pm

Abhinav S

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2015-09-17T16:57:00

Solution 1

Just a rough guess, but since the SQL Server service runs as an account that is not YOU, it doesn't have access to what I assume is a network drive. Copy the file locally to the server and try it from there. I'd be willing to be it works.

Posted 17-Sep-15 16:57pm

Dave Kreskowiak