copying files

[swoodring]

I need to copy a bunch of files into 1 text files so that I can use it to bring into sql server 7.0 using DTs and do an update. The data that I need to copy is on another server. I would like to copy the files into one file onto the server that has sql server. I'm assuming I shoould do this with a active x vb script. I really haven't used this feature and really don't know vb. I was wonering if anyone might have a sample they would be willing to share.

The data on the other server would be in a directory like the following where 001 and 002 would be folders for each store. We would have one for each of are stores.

Poll
Up
Archives
001
tlogs21.514
tlogs21.515
002
tlogs21.513
tlogs21.514
tlogs21.515

Also the files that I would want to copy would only be the current days so if today were the 15th I would only want to copy tlogs21.515. What I woould want to do is copy all the data to a file called tlogs.txt and when I'm done with it I would then want to delete it. There might not be a file in every store folder. If they didn't poll for some reason there would be no such document.

I figure I need to read through all the folders under archives so 001, 002, 003,004....etc and then if a document exists with the correct date extension I would copy it to the other server *add.

But I'm not sure how to go about this. any ideas/samples would be greatly appreciated.

Stacy