Hi All -
Can anyone please help me on a task that I been trying to figure out for days. I have an XML file that gets created everytime I execute an Access program and this XML file get overwritten everytime I re-run the Access program. However, I need to archive the XML file some I can do some reportings. So my plan is to write a bacth file to 1st copy the XML file to another folder, 2nd rename it with an incremental number (ex. extract001.xml -- this the part I can't seem to figure out) , and 3rd launch the Access program and re-run it.
This is what I have so far.
XCOPY \\di-upload\di-st_perf\HealthCare-ID\Extraction_Batch.xml \\di-upload\perf_data\xml /s /y /d /i /h /c
REN \\di-upload\perf_data\xml\Extraction_Batch.xml "Extraction_Batch%5#.xml"
Any help or suggestion I greatly appreicated.