How to export data from SQL server to Excel | Export table records to Excel | SQL DBA

In this video you will learn how to export SQL server table records to a excel sheet.
Want to know how to import data from excel to SQL database then click on below link to watch the video.
• How to import data fro...
‪@righttolearnbk‬

[@joshuajato3878]

Good video. Very easy to understand. Thank you.

[@Mohitkumar-fr3nn]

But in my sql server management studio there is no option of Sql server native client 11.0. What should I do?

[@yvi.weiwei5882]

I having error message the operation could not be completed login failed for user xxx(Microsoft sql server native client) may you suggest how to solve

[@vishy161]

Is there any way to do this via stored procs ?

[@Vishnu_Lover]

Thanks Sir ❤❤

[@anantghorpade9496]

excillent sir i tried but only headers of the colums copied can guide me please

[@upentalks]

Thank you BK sir

[@amruthacv2432]

Sir if I were to make changes in the excel sheet will it reflect in the database?

[@datboi6066]

no, it doesnt...youre exporting from sql nothing you do in excel affects sql

[@amruthacv2432]

Do u by any chance know how to do it ?

[@dineshbalu2038]

but how to import mysql workbench could u please make a video

[@sarahelen1877]

but that is with the wizard, ¿how can we export to Excel without SSIS nor the Wizard, but with SQL commands?

[@Abhibhojyan]

if we want to export those data which we get after excute a command ,only want execute data

[@amruthacv2432]

Sir what to do if Microsoft is not registered in local machine?

[@anantghorpade9496]

sir how generated the querry to see what is inside the table

[@artisingh226]

I want to learn mssql. can you help

[@monkeyman00010]

TY SO MUCH SIR

[@nakibrahaman2228]

external table is not in the expected format

[@venkatasuryasaip5239]

Hi sir will you please upload about blocking and deadlocks and Fragmentation and their troubleshooting and resolutions please

[@righttolearnbk]

Ok

[@RohitKumar-cg9ns]

Plz tell how to import excel file qsl severe

[@bhavanikancharla3904]

Hi, Could you please explain hyper-v and cluster as well

[@righttolearnbk]

Sure.
Please find videos in MS Sql playlist on Windows failover cluster service or click below links to watch
th-cam.com/video/Y5tz_70ktHc/w-d-xo.html
th-cam.com/video/IHzynh0CnpI/w-d-xo.html

[@bhavanikancharla3904]

@@righttolearnbk Thank you so much for your response

[@laileshm1183]

Copy paste bhi kr skte he na

[@righttolearnbk]

Yes, but copy paste will not work for large amount of data

[@Abhibhojyan]

headers copy ni honge

[@man525]

How to export 20 million rows

[@panplusk9539]

Why not just copy paste? Takes 2 seconds instead of 5 minutes? ;)

[@righttolearnbk]

You can do it but there is also a limit for copy paste, if yiu have some million records you cannot do it

[@panplusk9539]

@@righttolearnbk Havent thought about that, You're right. Thanks.

[@anantghorpade9496]

sir how can i contact you