Description:
You're running an ad-hoc query in a Microsoft SQL Server database with SQL Server Management Studio (SSMS) and need to further analyze the result set in an Excel spreadsheet. How do you export the data?
SSMS gives us this option to get our results to Excel:
COPY TO EXCEL - 1. Click the box in the upper left-hand corner of the Results pane to highlight all records
2. Click on Copy with Headers or Ctrl+Shift+C
Open a blank workbook in Excel
1. Right-click
2. Paste
????PLEASE LIKE and SUBSCRIBE???? - this will boost our motivation to create even more amazing videos.
Be a SQL HERO!
How do you copy to excel ? #sql #excel #datascience #copy #dataengineering #dataanalytics #sqlserver #data
Share this link via
Or copy link