locked
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.

     

    Samagra

     

     

    Wednesday, October 27, 2010 6:20 AM

Answers

  • 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

    Scot

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