Problem loading Excel 2013 files (32 bit) with Microsoft Visual Studio 2008 (SSIS) (64 bit)

• sa_ssis

  SSC Rookie

  Points: 48

  More actions

  September 15, 2014 at 10:44 am

  #311614

  Hello,

  I am having a problem loading Excel 2013 files (32 bit) with Microsoft Visual Studio 2008 (SSIS) 9.0.30729.4462 (64 bit) Version 3.5 SP1, after upgrading from Excel 2010 (32 bit), on a 64 bit Windows 7 Professional Service Pack 1 machine.

  Can anyone help?

  In the past I needed to go to the property tab under the project, and change the "Debug Options: Run64BitRuntime" to "False", but it is still not working (these are the defaults I used in the past).

  Stephen

• sa_ssis

  SSC Rookie

  Points: 48

  More actions

  September 15, 2014 at 3:57 pm

  #1745621

  I downloaded and installed this program to solve the problem:

  "2007 Office System Driver: Data Connectivity Components"

  http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

  at the suggestion of one of my co-workers.