Nov 11 2011, 11:41 AM
Hello. I need to send a lot of data to Excel from Access. There is a parent loop and a child loop. The parent loop has 7000 records. The child loop has 32000 records. It takes way too long to go through each parent record and send it and it's child records to excel. The child records are also grouped with the parent in Excel. Is there a faster way to do this than with loops? Thank you.
Nov 11 2011, 01:53 PM
7000 records, by 32000 subrecords = 200 million iterations
how big is your spreadsheet?
are you sure this all fits on a single spreadsheet?
Nov 11 2011, 03:43 PM
Hi Gemmathehusky. I am sorry, I miscommunicated that. The 32000 child records are divided amoung the 7000 parent records. So the total record count is less than 40000. It looks like using a union query will put everything on the spreadsheet at once. I will try to run a small loop afterwards to add the groups.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here