Unable to Import from Spreadsheet

Question

Hi,

I am using SharePoint 2010 and want to import a Excel-Spreadsheet as a List to the SharePoint.
When I try to do this, the selected Excelfile opens with Excel 2010 and then it appears an error:

"Could not load an object because it is not available on this machine."

Then I press "OK", the VBA-Developer opens and it says:

"Compile Error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute".

Again I press "OK", Excel closes and in the SharePoint it appreas:

"An unexpected error has occurred. (-2147352567)"

What is this all supposed to mean? And how can I solve the problem?
Thanks in Advance

Answer 1

Hi,

here is the solution, the KB is for office XP and MOSS 2007 but definitely you can give it a chance to 2010 products 

http://support.microsoft.com/kb/833714, because t is most likely caused due to the Owssupp.dll is lost or not register correctly. I suggest you to register the Owssupp.dll file according to the following KB article: http://support.microsoft.com/kb/833714 

hope this helps

---

Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Thanks for the quick response.

It is working now, Thx