groups_mw@yahoo.com wrote:

> 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!