Results 1 to 3 of 3

Thread: DTS Import Excel file using SQL Server 2000

  1. #1
    Join Date
    Jan 2005
    Posts
    13

    DTS Import Excel file using SQL Server 2000

    I am trying to import an Excel file - when I pick the file I get the message "Could not open file for reading. Close any other application that may be locking the file."
    I have verified that the file is not open - I have even rebooted the machine - still the same message - what am I doing different?
    Please advise.
    Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Tried do it from another sql server?

  3. #3
    Join Date
    Nov 2007
    Posts
    1

    Try moving file to another directory

    I ran into this problem and found a work around moving the file to another directory higher up in the tree. Have not determined if there was an issue with the particular directory or if the reference had too many levels. Am running a local (SqlSvr 2K SP2) server under XP Pro.

Posting Permissions

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