Error on Import

[shaunk]

I have an Excel spreadsheet in 2000 format which I plan to import to a table in SQL Server.
The spreadsheet is closed and no other application is using the spreadhseet, but on import I am getting the error "Could not open file for reading. Close any application that may be locking the file"
Thanks

 

[yksvaan]

I don't know if it's the case here, but I've seen it in so many cases, that I strongly recommend never to import/export files in network resources. First copy the file to sql's server with a bat or something, which you can launch with Execute Process task or within sp with
exec master..xpcmdshell "copy ASO
And on export, make the file on sql-server and copy it to network.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]