[!--quoteo(post=358177:date=Mar 25 2006, 03:54 AM:name=draxxus)--][div class=\'quotetop\']QUOTE(draxxus @ Mar 25 2006, 03:54 AM) [snapback]358177[/snapback][/div][div class=\'quotemain\'][!--quotec--] Maybe write a local script to gather all the names? You can split the file names up into seperate strings wherever a "_" is. Then have another script append any neccessary info so that you could just copy/paste into sql. Only way I can think of :) [/quote] Hello draxxus, I do have a program to spit out the file name.... So for example, I can easily convert Publisher_Author_Date.pdf to the text Publisher_Author_DATE. Now what? I am totally new at this...has been only 2 days.. and already feel like giving up! How will I change Publisher_Author_Date to something something which then I can import to mysql table. Please tell me a step by step process.