Querying data using SQL statements in Excel

For data analysis in Excel, you can use SQL statements for data analysis in addition to a powerful PivotTable report, if you need to be familiar with SQL statements.

First we look at the employee data sheet. That is, the data source

650) this.width=650; "style=" Float:none; "title=" 11.JPG "src=" http://s3.51cto.com/wyfs02/M00/6C/84/ Wkiol1vlkyiacqfiaam-la1dg6g435.jpg "alt=" Wkiol1vlkyiacqfiaam-la1dg6g435.jpg "/>

Here we will use the existing connection. We'll share it later. From other data sources, you can create a table in a named way

650) this.width=650; "style=" Float:none; "title=" 12.JPG "src=" http://s3.51cto.com/wyfs02/M00/6C/89/ Wkiom1vlkbuhospeaaggmhqoyoy730.jpg "alt=" Wkiom1vlkbuhospeaaggmhqoyoy730.jpg "/>

It will appear after you click and then click Browser For more

650) this.width=650; "style=" Float:none; "title=" 13.JPG "src=" http://s3.51cto.com/wyfs02/M01/6C/84/ Wkiol1vlkzpr7pb6aaf9imf2y3a742.jpg "alt=" Wkiol1vlkzpr7pb6aaf9imf2y3a742.jpg "/>

Then select the data table. He turned sheet into a data sheet.

650) this.width=650; "style=" Float:none; "title=" 14.JPG "src=" http://s3.51cto.com/wyfs02/M01/6C/89/ Wkiom1vlkcsicviyaaelcb2cpfs682.jpg "alt=" Wkiom1vlkcsicviyaaelcb2cpfs682.jpg "/>

After you click OK, the following dialog box appears. Click Properties

650) this.width=650; "style=" Float:none; "title=" 15.JPG "src=" http://s3.51cto.com/wyfs02/M01/6C/89/ Wkiom1vlkcjga9wiaadc4gmdza4583.jpg "alt=" Wkiom1vlkcjga9wiaadc4gmdza4583.jpg "/>

Then you can enter the SQL statement ... Note a few options.

650) this.width=650; "style=" Float:none; "title=" 16.JPG "src=" http://s3.51cto.com/wyfs02/M02/6C/84/ Wkiol1vlkagxqaivaag_-jeydlu147.jpg "alt=" Wkiol1vlkagxqaivaag_-jeydlu147.jpg "/>

In is the statement select * FROM [sheet3$] where sex= "male"

650) this.width=650; "style=" Float:none; "title=" 17.JPG "src=" http://s3.51cto.com/wyfs02/M00/6C/84/wKioL1VLKaeDJA_ Uaagoituycck430.jpg "alt=" Wkiol1vlkaedja_uaagoituycck430.jpg "/>

Once executed, the results will appear.

650) this.width=650; "style=" Float:none; "title=" 18.JPG "src=" http://s3.51cto.com/wyfs02/M00/6C/89/ Wkiom1vlkdmssqggaalzgnk_z7g969.jpg "alt=" Wkiom1vlkdmssqggaalzgnk_z7g969.jpg "/>

This is a way for SQL to apply the most basic in Excel

You can read a book called

650) this.width=650; "title=" 20.JPG "src=" http://s3.51cto.com/wyfs02/M00/6C/89/wKiom1VLLYLCvu21AAF53Jde7N0973.jpg "alt=" Wkiom1vllylcvu21aaf53jde7n0973.jpg "/>

This article is from the "Guo Yong Technology blog" blog, make sure to keep this source http://guoyong.blog.51cto.com/408495/1643944

Querying data using SQL statements in Excel