How to import excel file in 64 bit sql server

• RamG

  Right there with Babe

  Points: 767

  More actions

  April 1, 2009 at 7:19 am

  #132762

  Hi,

  I am using sql server 2005 running on 64 bit system, While importing the data from excel file to table I am getting the error as 'The OLE DB provider "Microsoft.Jet.OLEDB.2.8" has not been registered.' Please help me how to solve this problem.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  April 1, 2009 at 7:51 am

  #969838

  I have covered that error in the thread below.

  http://www.sqlservercentral.com/Forums/Topic686672-146-1.aspx#bm687570

  Kind regards,
  Gift Peddie