Hi all I am looking for some help please with the following with my windows system- I'm looking to export data to a new database with a different file structure. Filed mapping is fairly straightforward but handling attached documents is giving me a headache... many thanks in advance ..... My database (sybase) stores documents outside the database and links to them. The database links to 5 category folders ( eg Clients, suppliers, events etc ) and each contains many sub folders that are numbered such that the last folder in the group contains documents. Each document ( word, pdf etc) has a unique reference number generated by the database and is prefixed by the client number so all documents for the same client are grouped together. The file structure is related to the client number, so for example document files relating to client 0110667 are found in this folder structure :- CLIENT\01\10\66 and in the 66 folder are 10 sets of client documents for the following client ref numbers.. 0110660 to 0110669. So in my example above I have 2 uniquely named documents .. 1 word and 1 pdf ( in the prefix the leading zero is dropped) 110667.134721.doc 110667.137775.pdf What I am trying to do is extract all of these unique document files from the dozens of subfolders into one large master folder. There are too many folders to do this manually and I wondered if there was some batch file code or other script that some one could help me write to automate the process that would systematically work its way through each folder until it found files ( not every folder has files in them) and copy what it finds into One master folder. There are only document files in the last folder of the structure that drills down to each group of 10 client numbers in question The whole structure is as follows - I hope what I'm trying to put across is clear CLIENT\ 01\ 02\ . . . 99\ CLIENT\01\00\ 01\ 02 \ to 11 CLIENT\01\00\01\ 02\ to 99 cheers.