Posted by groups_mw on 10/07/05 01:57

Same with OpenDataSource. SQL 2000, logged in as non-SA.

Getting message:

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

Can run with SQLOLEDB with connection string to same server
(obviously), but when trying to access an Excel file, get the message
above.

It appears that the file name given in the connection string to Excel
is with respect to the SQL server, so I have used UNC names to the
file. Nothing.

Want to avoid DTS when it's a table that I need and can't use a linked
server because it's always a one time thing.

Any tips appreciated!

[Back to original message]