I have a new SP 2007 site which I have been loading about a terabyte of files into. File types include .doc, .docx, .ppt, .pptx, .xls, .xlsx, .xlsm, .jpg, .gif, .pdf.
What I need to do is add custom metadata for each file. Fields include project name and department. Since there are a large number of files, adding the data manually isn't an option.
How could I add it in bulk?