I'm trying to write a batch file that renames text files in a specific folder to specified name.
Ex. datafile03102011.txt --> datafile.txt
datafile03112011.txt --> datafile.txt
datafile03122011.txt --> datafile.txt
The reason why I need to do this is because I want to automatically upload delimited text files into MS Access and that is hard when the file name is constantly changing. It's an easy task if the file name stays constant so I want to write a .bat file to automatically convert these files to the same file name.
Any help would be greatly appreciated.