Forum Discussion

Storm214's avatar
Storm214
Copper Contributor
Feb 11, 2020

Analyzing Data with Excel

20779 B Analyzing Data with excel: I have been trying to work out how to be able to download the SQL file that I need to import into excel. My course book mentions logging into a Hyper-V system, and ...
excel
Abiola1's avatar
Abiola1
MVP
Feb 11, 2020
Hello, the video link below shows exactly how to extract bak file in SQL Management Studio

https://m.youtube.com/watch?v=mRI8vpn-tyk&t=4s

After you have the Adventure file in your SQL database table, then you open a new blank Excel workbook and click on Get Data.. Select SQL Server and your Server name...
Storm214's avatar
Storm214
Copper Contributor
Feb 13, 2020

Abiola1 

 

Thank you for you response! This has been harder than I expected.

 

There is a mention of using a virtual machine which then links to having access to the SQL. It also mentions hyper-v. I am not entirely sure what to do. Do I download the hyper-v so that I can access the virtual machine details they provided, and then access that? I was able to download the bak, but not sure if supposed to access on the virtual machine and load on SQL, and then sort out import into excel? Or if I just try to set up the SQL myself, and then load the bak I downloaded?

 

When I downloaded the SQL Server Management Studio, I then got stuck on how to set it up.

 

 

 

Any advice?