locked
Import Excel to Sharepoint List 2010 RRS feed

  • Question

  • Hi,

           I need to import an excel file to Sharepoint list without using manual import (Import to Excel). Instead, I want to import automatically by specifying the path of the Excel sheet or by using any Scheduler. Suggest me...

    Friday, November 30, 2012 9:19 AM

Answers

  • Hi,

    You can use lists.asmx webservice where you can use oledb connection to import excel data into list. Please see the below blog for code:

    http://salaudeen.blogspot.in/2012/06/read-from-excel-import-to-sharepoint.html

    You can also use office API to read excel file and copy data into list but it would be require visual studio to write code for custom timer job. If you happy with that then may got with this.

    Hope it could help


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer


    • Edited by Hemendra Agrawal Friday, November 30, 2012 9:39 AM
    • Marked as answer by Emir Liu Thursday, December 6, 2012 7:44 AM
    Friday, November 30, 2012 9:39 AM