How to export data from table exceed 5 milion rows to excel?

Transact-SQL
, ,
1

I work on sql server 2019 i face issue i can;t export data have 5 milion rows to excel multi sheet

so what best tool or techniqque i can use oit from sql server to export 5 milion rows to excel

multi sheet quickly and on same time performance is good

2

You can't export? What does that mean? Can you show us what you tried?

3

So obviously seems like you are waiting for someone to provide a solution for your work