Hi all,
I have an Access database that once a month goes through a 30 gigs of
text files extracting that month's data. Of the 30 gigs, about 3-4
gigs is recent enough to relate to the last month's bill run.
By running a batch script along the lines of "xcopy /s /d
H:\WapRecords| M:\tmpWapRecords\" I can copy the relevent text files
and run the import in 2 hours as opposed to an overnight run.
The big advantage here is that my import script involves a lot of
dickering about with file headers, trailers, etc. and I wanna be there
in case it bombs out. Having it bomb out of a 14 hour run and then
having to re-run it would involve me having a none too pleasant chat
with the Chief Accountant along the lines of "If we miss month end
bill runs, what is it we pay you for?" Lets whip out those violins
and play a sad tune :-(
Anyway, I want to make the ability to make this functionality
available outside of Access. vbscript looks ideal in that I can use
the same function both in Access and in a desktop applet.
I've never written vbscript but if someone could direct me to a
tutorial or link where I can find out how to do a copy of all files
created/altered after a certain date with their directory structure
intact, I'd be grateful.
Patrick