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 doing it from there. The 3 day course I did in a classroom had access to a hyper-v that could access and sort out the file, but on my own I don't know how to proceed. Adventure Works L T 2012. As far as I can tell, I need to be able to import the Adventure Works L T 2012 into excel.  won't let me open or use the file as it is a . b a k and my laptop doesn't support that file. Any help will be greatly appreciated!

excel

3 Replies

  • 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?