MS SQL Server - Linked Serevrs

Author

Linked Serevrs

Mukut

2006-10-24, 6:37 pm

Hi All,

This is an urgent issue. In our project, we are using a stored
procedure which populates a table in sql server 2000 database by taking
value from an excel file.
While running the sp, the error we are getting is as follows:

Server: Msg 7415, Level 16, State 1, Line 1

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

End procedure: p_checkfile, 14 Oct 2006 15:31:24:750

INSERT MDS_LOV SELECT * FROM OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0','Data Source="C:\Dump\LOV.xls";Extended
properties=Excel 8.0')...[Sheet1$]

Under this situation,
we have tried to create a linked server(in Enterprise manager) which
specifies an OLE DB provider that can use excel file as an OLE DB data
source.But we failed to create that.
We are not sure about the following parameters:
Product Name:
Data Source:
Provider string:
we have choosed Microsoft.Jet.OLEDB.4.0' as Provider name.

Can anyone help us?

Apologies for any mistake or inconvenience in understaking the above
points.

Thanks
Mukut

Arnie Rowland

2006-10-24, 6:37 pm

Example:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended
Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

From:
http://www.connectionstrings.com/

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"Mukut" <hidevraj@gmail.com> wrote in message
news:1160828140.229153.287790@h48g2000cwc.googlegroups.com...
> Hi All,
>
> This is an urgent issue. In our project, we are using a stored
> procedure which populates a table in sql server 2000 database by taking
> value from an excel file.
> While running the sp, the error we are getting is as follows:
>
> Server: Msg 7415, Level 16, State 1, Line 1
>
> Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been
> denied. You must access this provider through a linked server.
>
> End procedure: p_checkfile, 14 Oct 2006 15:31:24:750
>
> INSERT MDS_LOV SELECT * FROM OPENDATASOURCE
> ('Microsoft.Jet.OLEDB.4.0','Data Source="C:\Dump\LOV.xls";Extended
> properties=Excel 8.0')...[Sheet1$]
>
> Under this situation,
> we have tried to create a linked server(in Enterprise manager) which
> specifies an OLE DB provider that can use excel file as an OLE DB data
> source.But we failed to create that.
> We are not sure about the following parameters:
> Product Name:
> Data Source:
> Provider string:
> we have choosed Microsoft.Jet.OLEDB.4.0' as Provider name.
>
> Can anyone help us?
>
> Apologies for any mistake or inconvenience in understaking the above
> points.
>
> Thanks
> Mukut
>

Sponsored Links