467,149 Members | 1,244 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

BULK INSERT Question

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
  • viewed: 1292
Share:
2 Replies
ck9663
Expert 2GB
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+
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.

Similar topics

2 posts views Thread by Chris | last post: by
2 posts views Thread by php newbie | last post: by
20 posts views Thread by akej via SQLMonster.com | last post: by
6 posts views Thread by pk | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
11 posts views Thread by Ted | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.