LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Donna YaWanna
 
Posts: n/a
Default 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"


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from files with different names to EXCEL D'base. thunderfoot Excel Discussion (Misc queries) 2 June 10th 05 11:05 AM
Automatically opening several Excel Files at startup Peo Sjoblom Excel Discussion (Misc queries) 0 June 8th 05 05:20 PM
Excel Files Acting Weird Anat Excel Discussion (Misc queries) 0 March 29th 05 03:07 AM
Linking Excel files -- I cannot find an answer anywhere. MAB Excel Discussion (Misc queries) 0 March 28th 05 06:47 PM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM


All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"