Analyzing Data with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1167397%22%20slang%3D%22en-US%22%3EAnalyzing%20Data%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E20779%20B%20Analyzing%20Data%20with%20excel%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EI%20have%20been%20trying%20to%20work%20out%20how%20to%20be%20able%20to%20download%20the%20SQL%20file%20that%20I%20need%20to%20import%20into%20excel.%26nbsp%3BMy%20course%20book%20mentions%20logging%20into%20a%20Hyper-V%20system%2C%20and%20doing%20it%20from%20there.%20The%203%20day%20course%20I%20did%20in%20a%20classroom%20had%20access%20to%20a%20hyper-v%20that%20could%20access%20and%20sort%20out%20the%20file%2C%20but%20on%20my%20own%20I%20don't%20know%20how%20to%20proceed.%26nbsp%3BAdventure%20Works%20L%20T%202012.%26nbsp%3BAs%20far%20as%20I%20can%20tell%2C%20I%20need%20to%20be%20able%20to%20import%20the%20Adventure%20Works%20L%20T%202012%20into%20excel.%26nbsp%3B%20won't%20let%20me%20open%20or%20use%20the%20file%20as%20it%20is%20a%20.%20b%20a%20k%20and%20my%20laptop%20doesn't%20support%20that%20file.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EAny%20help%20will%20be%20greatly%20appreciated!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1167397%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1167448%22%20slang%3D%22en-US%22%3ERe%3A%20Analyzing%20Data%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167448%22%20slang%3D%22en-US%22%3EHello%2C%20the%20video%20link%20below%20shows%20exactly%20how%20to%20extract%20bak%20file%20in%20SQL%20Management%20Studio%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DmRI8vpn-tyk%26amp%3Bt%3D4s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DmRI8vpn-tyk%26amp%3Bt%3D4s%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAfter%20you%20have%20the%20Adventure%20file%20in%20your%20SQL%20database%20table%2C%20then%20you%20open%20a%20new%20blank%20Excel%20workbook%20and%20click%20on%20Get%20Data..%20Select%20SQL%20Server%20and%20your%20Server%20name...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172214%22%20slang%3D%22en-US%22%3ERe%3A%20Analyzing%20Data%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20you%20response!%20This%20has%20been%20harder%20than%20I%20expected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20mention%20of%20using%20a%20virtual%20machine%20which%20then%20links%20to%20having%20access%20to%20the%20SQL.%20It%20also%20mentions%20hyper-v.%20I%20am%20not%20entirely%20sure%20what%20to%20do.%20Do%20I%20download%20the%20hyper-v%20so%20that%20I%20can%20access%20the%20virtual%20machine%20details%20they%20provided%2C%20and%20then%20access%20that%3F%20I%20was%20able%20to%20download%20the%20bak%2C%20but%20not%20sure%20if%20supposed%20to%20access%20on%20the%20virtual%20machine%20and%20load%20on%20SQL%2C%20and%20then%20sort%20out%20import%20into%20excel%3F%20Or%20if%20I%20just%20try%20to%20set%20up%20the%20SQL%20myself%2C%20and%20then%20load%20the%20bak%20I%20downloaded%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20downloaded%20the%20SQL%20Server%20Management%20Studio%2C%20I%20then%20got%20stuck%20on%20how%20to%20set%20it%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Storm214_0-1581611973214.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171105i351482B12815E499%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Storm214_0-1581611973214.png%22%20alt%3D%22Storm214_0-1581611973214.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172400%22%20slang%3D%22en-US%22%3ERe%3A%20Analyzing%20Data%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172400%22%20slang%3D%22en-US%22%3EHello%2C%20you%20need%20to%20install%20SQL%20Server%20on%20your%20system..%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20check%20my%20blog%20post%20on%20how%20to%20install.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.exceljetconsult.com.ng%2Fhome%2Fblog%2Fcomprehensive-sql-server-2017-installation%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.exceljetconsult.com.ng%2Fhome%2Fblog%2Fcomprehensive-sql-server-2017-installation%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThen%2C%20you%20can%20follow%20the%20first%20link%20I%20sent%20on%20how%20to%20extract%20the%20bak%20file%20%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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!

3 Replies
Highlighted
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...
Highlighted

@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.

 

Storm214_0-1581611973214.png

 

 

Any advice?

Highlighted
Hello, you need to install SQL Server on your system..

You can check my blog post on how to install.
https://www.exceljetconsult.com.ng/home/blog/comprehensive-sql-server-2017-installation/

Then, you can follow the first link I sent on how to extract the bak file