[AccessD] A2003: Merging top 50 files then next 50 files and so on

Hi Team

 

>From approx 5000 files I need to create approx 10 'blocks' of 50 files in each
block

I want to be able to get say the first 50 files in a folder - merging those 50
files into one file 

Then getting the next 50 and merging that lot into a second merged file etc and
so on

I can do the merge bit OK 

Does anyone have a clue on how to get the first 50 then the next 50 and so on
until all files have been merged into a handful of larger merged files?

 

FYI - they will all be individual XML files being merged into larger XML files
to speed up internal processes here 

 

MTIA


Darren