Select 500000 records and write to excel sheet till all records are processed

@RPA-botDev

Check below thread for your reference

Hope this will help you

thanks