The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

• bajoriasatyanarayan

  SSC Enthusiast

  Points: 117

  More actions

  April 30, 2009 at 4:12 am

  #203456

  Hi,

  Whenever i run the below query in sql server 2005

  Select *

  from OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Excel 8.0;Database=C:\OMESitesList.xls;',

  'SELECT * FROM [Sheet1$]')

  I am getting the error,

  The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

  Please help me regarding this.

  Thanks in advance

  Regards

  Bunty

• john-902052

  SSCommitted

  Points: 1578

  More actions

  April 30, 2009 at 8:50 am

  #986700

  Have you installed MDAC or the OLEDB provider on your server/workstation?