Importing a spreadsheet to a existing sharepoint list. - InfoPath Dev
in

InfoPath Dev

Importing a spreadsheet to a existing sharepoint list.

Last post 10-22-2008 01:00 PM by sirii. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 10-21-2008 02:25 PM

    • sirii
    • Top 500 Contributor
    • Joined on 10-02-2008
    • Posts 31

    Importing a spreadsheet to a existing sharepoint list.

    Hi,

    I have published a infopath form to a sharepoint site as a document library. I have added some fields of infopath form while publishing so that they would appear as columns in a sharepoint list.

    Consider the list name as "My_Template". Can I import a different excel spreadsheet with different fields to the "My_Template". So that the fields in excel spreadsheet also appears as columns in "My_Template". So the fields of infopath form and fields of excel sheet should appear as coulumns in a sharepoint list.

  • 10-22-2008 01:55 AM In reply to

    • ravig
    • Top 500 Contributor
    • Joined on 06-21-2008
    • Posts 27

    Re: Importing a spreadsheet to a existing sharepoint list.

    Hi, 

    To import Excel Spread sheet to SharePoint following link will help you.

    http://www.sharepointcustomization.com/wss/articles/lists-excel.htm

    But the fields of excel sheet will be displayed in seperate view.

    Ravi G
  • 10-22-2008 05:09 AM In reply to

    Re: Importing a spreadsheet to a existing sharepoint list.

    Hi,

     One of the option can be by adding an extra column and by copy/pasting from the spreadsheet to SharePoint:

    This can be done by going to Actions-->Edit in Datasheet

    Right clicking on the column and add column and paste the data from spreadsheet.

     

  • 10-22-2008 12:59 PM In reply to

    • sirii
    • Top 500 Contributor
    • Joined on 10-02-2008
    • Posts 31

    Re: Importing a spreadsheet to a existing sharepoint list.

    Thanks Ravi

  • 10-22-2008 01:00 PM In reply to

    • sirii
    • Top 500 Contributor
    • Joined on 10-02-2008
    • Posts 31

    Re: Importing a spreadsheet to a existing sharepoint list.

    Thanks Hari

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.