Excel Bulk Insert

• Sachin-558788

  SSC Veteran

  Points: 284

  More actions

  March 30, 2009 at 5:56 pm

  #136205

  I am trying to do this query for Excel bulk insert:

  INSERT INTO TestTable

  SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Excel 8.0;Database=C:\Test.xls;HDR=Yes;IMEX=2',Sheet1$)

  This query is working fine in my local computer.

  But I need to use this in my Server Computer where there is no MS Office installed.

  Is there any way to import Excel file with out installing MS Excel??

  Error i am getting is : The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

  Thanks,

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 30, 2009 at 6:38 pm

  #968817

  I think that you just need to install Jet. Check Microsoft, there should be a free download & install.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Sachin-558788

  SSC Veteran

  Points: 284

  More actions

  March 31, 2009 at 5:20 pm

  #969560

  I downloaded Jet40SP8_9xNT.exe package and installed it. But it didn't work.

  Still getting the same error.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  March 31, 2009 at 5:40 pm

  #969564

  That error means you are in x64 server so if you are in Win2003 you need to install SP2 which will install the x86 ODBC and if you are in Win2008 you may need the new Access runtime because Win2008 comes without MDAC.

  Kind regards,
  Gift Peddie