Jet Oledb on 64 bits RRS feed

  • Question

  • I am receiving the :

    Msg 7403, Level 16, State 1, Line 2
    The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

    error when trying to use opendatasource against an xls file on a 64 bit server with SQL Server 2005 and Windows 2003 64bit version.

    I did some initial research and found postings saying that Microsoft has not ported the Jet.OleDB to a 64 bit version. So the question is, is there a good work around? And are they planning to port it or create a replacement?

    I have considered using SSIS, but conditions here make it preferable to use OpenDataSource if possible rather than SSIS if possible.
    Monday, December 10, 2007 3:25 PM