Hi,
i am working with asp. I used the following code segment in my code
to retrieve the the data from an Excel file.It is a part of a SQL Query and I am executing this by an ADODB.connection object. It is working well in my local machine. But after I uploaded it to the web server, it is not working and it shows an error message. the following is the code segment.


OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=" &
filepath & ";', 'SELECT * FROM [Sheet1$]')"


Error message is:


Microsoft OLE DB Provider for SQL Server error '80040e14'

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.

/smspayroll/attach_xl_view.asp, line 74



Please tell me how to resolve this problem,

Thanks in advance.

by,
Ashok Kumar.K