By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

BULK INSERT Question

P: 1
I use Bulk insert to put data to myTable.
When the SQL server is in local machin, it works well. But when I put
the data in a sql server situated not locally, then I get a error
message like this:

This post is similar to others, but am at a lost to fix it.

Could not execute bulk insert because file 'Q:\SQLServerReport\01_DataLoad\
01_Site.xls' could not be opened. Operating system
error code 3(The system cannot find the path specified.).

Running BULK INSERT from a Stored Procedure:
BULK INSERT Eval_Site
FROM 'Q:\SQLServerReport\01_DataLoad\01_Site.xls'
with
(
keepnulls
)

The Q: Drive is the same as for SQL Server 2005 as the data file.

What gives?
Sep 4 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
Docs says:

data_file

Is the full path of the data file that contains data to import into the specified table or view. BULK INSERT can import data from a disk (including network, floppy disk, hard disk, and so on).

data_file must specify a valid path from the server on which SQL Server is running. If data_file is a remote file, specify the Universal Naming Convention (UNC) name.
Make sure your file can be seen from the sql-server.

-- CK
Sep 4 '08 #2

100+
P: 112
make sure you can access the file and also check sql can read the file.

Check also the drive letter you spicify you can browse. use command prompt.
Sep 8 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.