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.

7000 records, by 32000 subrecords = 200 million iterations

how big is your spreadsheet?

are you sure this all fits on a single spreadsheet?

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.