Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Aug 4 22:34:41 CDT 2008
Well, I'm not sure how much detail to get into here. So I'll just take the high level view and let me know if you need more detail. Table is probably easier if you're not familiar with arrays. Since you say you can do the merges, I'll assume you have some way to get the file names one by one and merge the files. So create a table - one field - text - stash all the files names in there one by one (use DAO). Set the recordset pointer back to the first record. Open your first output file. Initialize a counter to 0. Use a Do While rs.EOF = False fetching each file name in turn. Open it and merge it into the output file. Bump your counter. If the counter=50 then close the output file, open the next output file, and set the counter back to 0. Stuart just posted something that looks like a real good framework. Will this work for you? 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 6:05 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] A2003: Merging top 50 files then next 50 files andsoon Brilliant - how do I do that? (Remember you are dealing with a luddite-Be quiet Andy) Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Tuesday, 5 August 2008 10:51 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] A2003: Merging top 50 files then next 50 files and soon 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com