merging my excel files
I create several .csv files every day. The total number of files varies. So
do the file names. All the file names have a date and time stamp in them. I want to be able to merge these files into a single file a couple times during the day. I don't want to delete or rename the originals - I just want to be able to verify the data going into the files is valid. Opening one file is easier than opening maybe 25 files and if they're all merged I don't have to worry about missing any. How do I create a batch file to merge all these files into a single csv when I don't even know how many files there are? I need some kind of wildcard trick, I guess. Any ideas? The file names are all something like "06-13-05 164423completedrecordswithexpense.csv" |
I'd just shell to the Command prompt:
Windows start command|Run (or flying windows r as a shortcut!) win98: Command WinXP/NT: CMD Go to that folder: C: (to change to that drive) cd\myfolder1\myfolder2\myfolder3 to change to that folder copy 06-13-05*.csv All-06-13-05.csv Exit to quit the shell. Then import all-06-13-05.csv Donna YaWanna wrote: I create several .csv files every day. The total number of files varies. So do the file names. All the file names have a date and time stamp in them. I want to be able to merge these files into a single file a couple times during the day. I don't want to delete or rename the originals - I just want to be able to verify the data going into the files is valid. Opening one file is easier than opening maybe 25 files and if they're all merged I don't have to worry about missing any. How do I create a batch file to merge all these files into a single csv when I don't even know how many files there are? I need some kind of wildcard trick, I guess. Any ideas? The file names are all something like "06-13-05 164423completedrecordswithexpense.csv" -- Dave Peterson |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com