Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2002
    Posts
    10

    Question Unanswered: why SQL2k can't see my file ?

    hello !
    I'm trying to execute this code :


    BULK INSERT intranet.dbo.HRAnn FROM 'c:\HRAnn.txt'

    ,

    and it generate me the message:

    "Could not bulk insert. File 'c:\HRAnn.txt' does not exist. "

    and the file is there ...

    thanks.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    The following is a clip from bol:

    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.

    If you use c:\filename, then this file must reside on the same machine as sql server - otherwise you will have to use UNC.

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    is 'c:\HRAnn.txt' on your PC or on the SQL Server? If it is on your PC then you will need to give an absolute path to the file i.e. '\\<my pcs name>\<sharepoint name>\HRAnn.txt'
    Paul Young
    (Knowledge is power! Get some!)

  4. #4
    Join Date
    Jun 2002
    Posts
    10

    Good point !
    I tried to work to an remote machine, while I expected
    the file to be found in my HD !
    Thanks !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •