However OPENROWSET only works for
\\server\wwwroot$\file.xls
Otherwilse error message returned =
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider
did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: The provider did not give
any information about the error.].
I think there might be a permissions problem somewhere : maybe domain, maybe
sql service account. Question is: what context / account is used to execute
openrowset for each of above?
Re: Difference between openrowset and opendatasource ... No. Openrowset() does not allow you to use 4-part-name. ... >> for an OLE DB provider using the SQL Server DisallowAdhocAccess property.... >> data source on the network that can be accessed using that OLE DB> provider. ... (microsoft.public.sqlserver.programming)
Help: Best way to Import data from EXCEL using a TSQL ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ..."Ian" wrote: ... (microsoft.public.sqlserver.odbc)
Help: Best way to Import data from EXCEL using a TSQL ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ..."Ian" wrote: ... (microsoft.public.sqlserver.datamining)
Help: Best way to Import data from EXCEL using a TSQL ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ..."Ian" wrote: ... (microsoft.public.sqlserver.server)
Help: Best way to Import data from EXCEL using a TSQL ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ..."Ian" wrote: ... (microsoft.public.sqlserver.programming)
