Export lakhs of records to excel from sql server table

Question

Dear Team,

 

I need to export total 84,59,700 records from sql server table to excel.

 

I tried in the following ways -

1. Import Export Wizard - Issue faced - Query could not be parsed.

2. Query execution - Not being executed.

 

Please guide - How do I do this ??

 

 This will be of great help..