Import Excel Spreadsheet and include documents to a Sharepoint 2010 list

Experts,

My organization is using SharePoint 2010 Enterprise, and I would like to create a SharePoint list versus a document library.  My audience is management, so I do not need anything fancy.  

I have an excel spreadsheet that I want to import into SharePoint, but one of the columns is a reference to a document.    I would like to have the document attached to the "list item" when I import the spreadsheet into SharePoint.   What would be my best course of action?  I would prefer an automated process versus having to attach all of the documents individually.

Thanks
DebbieHamataniAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
Hi,
afaik there is no ootb solution for this.
Do you have a unique business key in the Excel sheet?
Is the sheet updated on a regular base hence you will need an automated "sync" process?
Where are the referenced documents located?
Can you have multiple documents referenced in the same row/cell?
Are the referenced documents unique or are there multiple references to the same document (duplication)?
What should happen if a document is updated?

In general I would recommend to build a custom Powershell script. This should offer all necessary possibilities, can be schedulded, can be tested ...

HTH
Rainer
0
DebbieHamataniAuthor Commented:
Hi Rainer --

There  is no key in the excel spreadsheet now.
The sheet is updated on a regular basis, so a syncing process should be in place.
I think the documents will be uploaded to SharePoint.  If not, they will be linked to a shared file server.
You cannot have multiple documents for one row of data.  Each row is associated with one document and each document is only reference once.
I am hoping that the referenced documents will be stored in SharePoint and version control not necessary.  If my managers want version control on the documents, then I will need to create a document library.   Can a list synced with an excel spreadsheet, have the referenced documents contained in a document library?

Thanks for your help
Debbie
0
DebbieHamataniAuthor Commented:
With limited permissions, the only solution was to create a hyperlink column and import the spreadsheet with that column.  Unfortunately, there is tight security on the site that limits my ability to use development tools.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DebbieHamataniAuthor Commented:
I tested my own solution that was not given by the only comment to my question.  But I would like others to see my process.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.