oledb provider not registerd error

• jamessdba

  SSCrazy

  Points: 2256

  More actions

  October 15, 2010 at 9:18 am

  #388015

  SELECT *

  FROM

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

  8.0;Database=C:\test1.xls;IMEX=1','SELECT * FROM [Sheet1$]')

  when we execute the above query getting error like

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

  iam using below o/s& sql

  OS= Windows 2003 Std. Edition with SP2 x64

  SQL=MSSQL 2008 Std. Edition

  please suggest to fix this issue

• WayneS

  SSC Guru

  Points: 95461

  More actions

  October 15, 2010 at 9:23 am

  #1237639

  The microsoft jet drivers are only available in 32-bit systems.

  Edit: The 64-bit ACE drivers are available here.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• nzrdb6

  Say Hey Kid

  Points: 695

  More actions

  October 15, 2010 at 9:39 am

  #1237650

  You need the ACE 12.0 driver

• jamessdba

  SSCrazy

  Points: 2256

  More actions

  October 15, 2010 at 1:00 pm

  #1237821

  thank u very much for the quick replies

  MS Office 2003 is installed

  (excel files )

  i will install and check

  any of u experianced this issue pls reply

  replies are highly appreciated

  thanks in advance