Synopsis
本书是“Excel疑难千寻千解”丛书之一，为读者展示了在Excel 2010中运用SQL语句解决疑难问题的实战技巧。本书包含SQL基础入门、运算符、常用函数、日期、排序、聚合函数、连接查询、子查询、SQL与数据透视表、SQL与VBA等方面的应用技巧，以及SQL语句的综合应用。本书非常全面地阐述了SQL语言在Excel中的应用，SQL语法介绍具体全面，案例贴近实际，讲解深入透彻，帮助读者更加深入了解SQL语言，同时也揭开了SQL语言在Excel中使用的神秘面纱。
"synopsis" may belong to another edition of this title.
Search results for Excel 2010 SQL full application (including a CD-ROM)...
Seller Image
Excel 2010 SQL full application (including a CD-ROM)
Published by
Electronics Industry Pub. Date :2011-8-1, 2011
ISBN 10: 7121140373
ISBN 13: 9787121140372
New
paperback
Seller: liu xing, Nanjing, JS, China
Seller rating 5 out of 5 stars
paperback. Condition: New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Pages Number: 496 Publisher: Electronic Industry Pub. Date :2011-8-1. This book is excel solution difficult Spirited Away one thousand series. one for the readers with the use sql statements in excel2010 to solve difficult problems of practical skills. This book contains the fundamentals of sql. operators. commonly used functions. date. sort. aggregate functions. join queries. subqueries. sql with PivotTable. sql and vba application areas such as skills. and comprehensive application of the sql statement. This book is very comprehensive overview of the sql language application in excel. sql syntax on specific comprehensive. case close to reality. to explain the depth and thorough. to help readers more in-depth understanding of sql language. but also opened in excel using sql language of the mysterious the veil. Contents: Chapter 1 basis into 11.1 sql the sql language familiar excel environment a difficult one to get an external source of data 1 Interface through ole db 2 access to external data sources using microsoft query to import external data source to refresh 2 3 difficult to import 7 refresh external data import external data source 8 Troubleshooting 3 moved in the data source connection how to modify the data source path 9 automatically modified according to the pop-up prompts to move the file path 10 modified by modifying the connection string to move the file path 11 4 How difficult mixed type of field is forced to set the text field 11 forced to import external data source fields for the text 13 sql connection string in the Detailed 5 13 how difficult the security settings on the external data 15 external data 15 security settingsFour Satisfaction guaranteed,or money back. Seller Inventory # L99117
Buy New
US$ 90.80
US$ 18.00 shipping
Ships from China to U.S.A.
Ships from China to U.S.A.
Quantity: 10 available