Post reply

oledb provider not registerd error

  • 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

  • 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

  • October 15, 2010 at 9:39 am

    #1237650

    You need the ACE 12.0 driver

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply