Linked server to Excel file in SQL Server 2005 Enterprise Edition 64-bit

• Niri

  Grasshopper

  Points: 19

  More actions

  April 27, 2009 at 1:08 am

  #72734

  Hello All,

  I am using SQL Server 2005 Enterprise Edition 64bit with SP2 on Windows Server 2003 Enterprise Edition 64bit with SP2. During testing of application, I found out, SQL Server 2005 Enterprise Edition 64bit does not support excel import using MS JET OLEDB provider 4.0.

  So I tried office 2007 OLE provider as well but still no luck. Then I tried the option of creating Linked server but I got stuck. I just cant locate the OLE provider for office 2007 in the provider drop down list.

  Please assist on as to how can I get rid of this problem or at least please let me know how can create the linked server to link to an excel file that is to be imported.

  Regards,

  Niri

• dbk

  SSC Rookie

  Points: 25

  More actions

  May 26, 2009 at 12:32 am

  #999729

  Try this

  CON.Open "PROVIDER=sqloledb;DATA SOURCE=ip;DATABASE=databasenamel;USER ID=username;password=password"

  Bala

• Gosta Munktell

  SSCertifiable

  Points: 6004

  More actions

  May 27, 2009 at 2:48 am

  #1000411

  I would recommend that you save the Excelsheet(s) as tab separated textfiles and use bulkinsert instead.

  /gosta