Sharepoint List and repeating data

Question

Hi Everyone !!

So basically I am trying to work with Sharepoint List and am very much frustrated by one small thing. I have a request from my senior to make a form which has a list of IP addresses, Drac IP's etc. Now, every form could have any number of IP's (from 1 to 30 !!). I would love to have a repeating table but as that is not possible in Sharepoint List, I thought of looking in the option of Sharepoint Doc Lib. But the client has already a spreadsheet of 3000 + servers which I need to put in the list. This can be done very easily with the Sharepoint List (import spreadsheet) but not by Document Library. I am pretty new to the SP scene and dont know about customization too much , but I thought that SQL could help me out with this. But I dont have any idea how to use SQL for this. Could someone give me an idea on what should be my next step ??

Thanks a lot in advancE !!!

Answer 1

You can load your data into a SQL table and use SharePoiint Business Connectivity Services to view and search the data.

http://msdn.microsoft.com/en-us/magazine/ee819133.aspx

Answer 2

This could be a way for doing it .. But is it possible to load the data into the document library ? (just as how we have List Import Spreadsheet)

Answer 3

Yes, create a view with just the columns from the Excel SpreadSheet. Open the view in DataSheet view. You can now copy and paste the cells in from Excel.

Answer 4

Sorry Abhijit, it's not as simple as that, you would need to upload the documents first and then switch to the datasheet view.

Answer 5

Hmmm ... it seems that the new row in datasheet view for the Document library does not get enabled. Any idea anyone about how that could be made to work ?

Answer 6

New rows will only appear if a document is uploaded on that row. You can do a multiple document upload then copy and paste in the meta data.