64bit server compatibility?

Jan 7, 2010 at 3:10 PM

Hello

I like to tool and sucessfully implemented on 32 bit development server. Now I need to deploy on 64bit server, will this tool support 64 bit server? Secondly Do I also need to install ms office 2007 on 64 bit server to using excel oledb driver.

Please advise

Mar 28, 2010 at 3:40 PM

Folks,

For those interested in running this feature on a 64bit environment. try the following

 

  1. Download the 2010 Office System Driver Beta: Data Connectivity Components from
    http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en 
  2. Restart
  3. Locate spreadsheet.aspx
    Most likely here
    <drive>:Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS\SpreadSheet\spreadsheet.aspx
  4. Modify the connection for XLS to read
    @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + filePath + ";Extended Properties=\"Excel 12.0;HDR=YES;\""
     
  5. Test

These steps did work for us.

References: Connecting to Excel on a 64 bit server