SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a fairly large shared drive with various files that need to be migrated over to SharePoint.

I only have full control of my site, which is a subsite within the hierarchy.

I feel like if I were a scripting whiz this would be no problem.

I'm just starting out with about 400 Excel documents that need to go from the shared drive to SharePoint. Just a simple view is needed within SharePoint for relatively easy navigation.

Most workstations have Office 2010 (some 2003).



share|improve this question
up vote 1 down vote accepted

If you aren't able to write the script yourself, it may be time to hire a consultant. Otherwise you're looking at a manual process.

The method that would take the least amount of clicks in a manual move would be:

1) Open the file share in Explorer in one window.

2) Browse to the destination document library in SharePoint in your browser.

2007: Under Actions, click "Open with Windows Explorer"

2010: In the ribbon click "Open with Explorer"

(see images below)


Open with Windows Explorer


Open with Explorer

3) Copy and paste the files from the Explorer window of your file share to the Explorer window of your document library.

4) Wait.

5) Wait some more.

(This will take a very long time for a lot of files. You may want to do this on a machine dedicated to this task for the duration of your file move.)

Obviously if the files are all going to different document libraries this will take more user involvement. If you are moving files based on rules, metadata, or folder location, a script is probably the answer for you.

share|improve this answer
i'm just a technical aide so they don't expect much from me. pretty sure they tried outsourcing this stuff, but it was costing too much money so they scrapped it. It's a nice part-time gig while i'm in school - but i really want to do this the best possible way. i don't think i can script it becasue of my lack of priveledges. like powershell scripting right? can you point me towards a good book? also, what do you think of nintex forms? they seem pretty legit – Bill Sep 19 '12 at 17:55
Well then this is your easiest answer. It will just take a long time. A very long time. – RJ Cuthbertson Sep 19 '12 at 17:59
Your best guide for PowerShell scripting is MSDN. See… and If it is 2007 then you can't use PowerShell cmdlets. – RJ Cuthbertson Sep 19 '12 at 18:01
Our company is a Nintex reseller so I think my opinion would be biased. – RJ Cuthbertson Sep 19 '12 at 18:02
like the rest of my life long.. tried connecting powershell, no dice. we're workin with 2010 foundation. what about sharepoint designer for complete customization.. is that worth digging into. I've played around wuth it slightly, but I'm no web scripting expert. i get lost in the sea of different platforms, frameworks, etc.. – Bill Sep 19 '12 at 18:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.