Hello All,

I have tried to execute the following
"SELECT * INTO [Excel 5.0;Database=C:\ExcelFiles.xls].[Sheet1] FROM dbo.EmployeeTerritories "(NorthWind database) in SQL Query Analyser

as well as using DTS ActiveX Script, both are giving the following error message "Specified owner name 'Excel 5.0;Database=C:\ExcelFiles.xls' either does not exist or you do not have permission to use it."

the "C:\ExcelFiles.xls" does exist on the server

any ideas why this is happening, please help

regards
Sasidhar

thanks,
Sasidhar

__________________
thanks,
Sasidhar

Since you know it's there. then you don't have permission to use it.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

What kind of permission is required , can you please specify

thanks,
Sasidhar

The user accessing the file needs permissions to access it in the file system. Your system administrator should be able to set this up for you.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

We all have Administrator privileges with respect to FileSystem as well as in all the aspects.

thanks,
Sasidhar

Obviously the user that is trying to work with the file does not have such privleges. What user that is depends on how you have your system configured. It could be you, It could be ASPNET it could be IUSER_MachineName..

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee