Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Aug 4 19:50:56 CDT 2008
Get all the files names into an array or a table and use a counter to know when to switch to a new file as you iterate the array or table? Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D Sent: Monday, August 04, 2008 4:46 PM To: 'Access Developers discussion and problem solving' Subject: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com