I have a MOSS 2007 library. I've created a field called title, that I want to populate with the same data as the default Name field. Is there a way to run an update query to quickly do this for a couple of hundred documents?

I know I can use Access to update records for a List, but can this be done for a Library? I need to run an update query.

Hi Ryan, I understand that you want to update the title column to get value from Name column for all the existing documents in a document library. I have a test based on your description ,you cannot update the title column in Access using Update Query. Here are some workarounds: You can use SharePoint Designer workflow to update title column to get value from Name column.Edit the All documents view in SharePoint designer to set the title column to display the Name value. Right click on the Data view web part and choose Convert to xslt Find the title column in the code view. The code is like <xsl :value-of select=ddwrt:AutoNewLine(string(@title))> .Change it to <xsl :value-of select=ddwrt:AutoNewLine(string(@LinkFilename))> Thanks, Entan Ming TechNet Subscriber Support in forum If you have any feedback on our support, please contacttnmff@microsoft.com.Entan Ming TechNet Community Support