How to split Data table

Hi i need a help from u people i was having data table with 9lakhs to 15lakhs row we dont know the exact number but it will be in that range now i need to split that data table in to 2 data table so that i can create excel files by pasting them as excel cant take 15lakhs i need to split that in to 2 tables can any one help me please

Hi @bpt.teja1996 ,

Check the above link if that helps you.