Best approach to generate word document with huge table with 500k rows

I have a requirement to generate a word document with huge amount of data like a table with 500k rows…
I tired generating html first and then inserting it in the Word document but its taking hell lot of time to open it and getting frozen.
Is there a best way to generate these huge documents?
Thank and appreciate your thoughts.

@mp2,

I believe, Mail Merge with Regions is the best option in this case. But, please note that the maximum number of rows that you can add in a single Table in Word document is 32767. However, you can insert multiple mail merge regions (tables) to be able to insert data in 500k rows. Also, when the document containing the data is saved, it will then depend upon the MS Word application as to how quickly it will load this huge amount of data in it.

Thank you very much Awais

Let me give that a try

1 Like