Error when Importing Excel 2007 Files into SQL Server 2005

• dnf999

  SSC Eights!

  Points: 870

  More actions

  April 20, 2010 at 5:38 am

  #96914

  Hi

  When importing Excel 2007 data into sql via Import wizard:

  choose "Microsoft Office 12.0 Access Database Engine OLE DB

  Provider" as the data source in SQL Server Import and Export Wizard, then click Properties, switch to the All tab, input your excel file path to the Data source field and input "Excel 12.0" to the Extended Properties field and then click OK to follow the wizard.

  I get the following error:

  Error 0xc0202009: Source An OLE DB error has occurred. Error code: 0x80004005

  Error 0xc02020e8: Source Opening a rowset for failed

  Exception from HRRESULT: 0xc02020e8 (Microsoft.sqlserver.dtspipelinewrap)

  I have recently upgraded to Vista and did not have this problem in XP, does anybody know how to fix this, as I really need to get the data into SQL server 2005 (without using SSIS)

  Thanks!

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  April 20, 2010 at 5:40 am

  #1154468

  Can i just check that you meant to use the Access OLEDB to import an EXCEL table?

  EDIT: ignore me - hadn't realised you can use that for Excel inm the absence of Excel on the server.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]