Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Copying Multiple Files to SharePoint Document Libraries

By:   |   Updated: 2010-03-30   |   Comments   |   Related: > Sharepoint


I would like to copy multiple files to one or more SharePoint libraries. Is there any way to do it outside of using the "Upload" button, which limits you to files within a single folder?



There are several ways to do this, however, if your library has any required fields or 'check in' requirements, there will likely be some preparation steps you need to take. These might include temporarily removing these requirements or options. If you don't, the copying will work, but the files may be stuck in a 'checked out' status until you either check in the files or supply the required metadata.

Solution 1 - Using the "Windows Explorer" option in SharePoint

In the "Actions" menu of any Document Library there is an option called "Open with Windows Explorer". When you select this option, a new window opens. You can literally drag and drop files to and from this window.

Note: You will see a special folder called "Forms" in this window. Do not disturb this folder or use it unless you are specifically working with SharePoint form templates. That subject is outside the parameters of this article.

bulk documents

Solution 2 - Create a permanently mapped folder

In order to make it easier to administer your SharePoint environment, you may want to create a permanently mapped folder, to access SharePoint documents.

Below are instructions for creating this mapping in a Windows 7 environment. (Windows XP instructions later.)

Open Windows Explorer and right click on the "Computer" object. Then select "Add a network location.

add a network location

This will start the Wizard.

Click "Next" on the "Welcome to the Add Network Location Wizard".

add network

Highlight "Choose a custom network location" and click "Next".

network location

Type the web address of the base URL of your site collection. Then click "Next".


Type a friendly name for the object. You can leave the default or enter something new.

my portal

Click "Finish". If you leave the "Open this network location when I click Finish" checkbox checked, the location will open.

my portal

In either case, you will have a new object listed under the "Computer" icon, forever available to you.

my portal

In Windows XP, there is a similar Wizard in My Network Places. Below is a summary of the steps.

  • Start "Add Network Place"
  • Click "Next"
  • Select "Choose another network location" and click "Next".
  • Enter the URL of the target site collection (i.e. http://portal).
  • Give the object a friendly name (the default is fine or you can create one).
  • Click "Finish".

Solution 3 - Using SharePoint Designer

Using SharePoint Designer 2007, you can also copy files to and from the application interface. Source and destination objects can be:

  • SharePoint Designer to Windows Explorer
  • Windows Explorer to SharePoint Designer
  • SharePoint Designer to SharePoint Designer.
Next Steps

Last Updated: 2010-03-30

get scripts

next tip button

About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools