Monday, December 23, 2013

Issue with Excel - Microsoft Office Excel cannot access the file

Please refer to the below link

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/12/19/error-microsoft-office-excel-cannot-access-the-file-while-accessing-microsoft-office-11-0-object-library-from-ssis.aspx

Solution is as below
SOLUTION:
For Windows 2008 Server x64: Create the following directory:
C:\Windows\SysWOW64\config\systemprofile\Desktop
For Windows 2008 Server x86: Create the following directory:
C:\Windows\System32\config\systemprofile\Desktop

No comments: