O/S: Win2K / Access 2000
We receive text files every morning via e-mail attachments. Number of files varies depending on the day. Those attached files have all different file names. We import those data files (.txt) into MS Access. I created a macro from Access and it imports fine. However, before I import files, I have to manually rename files, so that Access can find a file name specified in the macro. (I tired to create a macro using *.txt as a file name, but it did not work.)
My question is - Is there any way, by running a batch file, I can rename file names based on how many files exist in a folder? For example, in a c:\file\, if there are 4 text files, I want to rename them to file1.txt, file2.txt, file3.txt and file4.txt. In this way, I can specified file names, file1.txt, file2.txt, file3.txt and file4.txt, inside the Access macro.
Your comments and advice are very appreciated. Thank you very much in advance. hb
Start Free Trial
