Sharepoint 2010 and Excel 2007 RRS feed

  • Question

  • Hi,


    I am creating a windows utility where user select list from a windows form combo box and inserting the excel data into the sharepoint list.

    Issue that i am facing is, SharePoint runs on VS2010 project properties Platform Target as "Any CPU" while excel 2007 driver "Microsoft.ACE.OLEDB.12.0;" workins with Platform target as "x86".


    Both are not working with each other, while if I am running them separately, they are working.


    Kindly suggest.





    Wednesday, October 27, 2010 6:20 AM


  • Several better solutions:

    1. Use the OpenXML SDK to get the data out of Excel

    2. Write an add-in for Excel instead of a Windows app

    3. Save the spreadsheets in SharePoint and use Excel Services to access the data


    • Marked as answer by Wayne Fan Thursday, November 4, 2010 2:20 AM
    Wednesday, October 27, 2010 10:28 AM