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
|