Provider Access Error
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.