Database Reference
In-Depth Information
How it works...
Microsoft Excel allows you to access external data from various data sources. Following
the instructions in this chapter, you have learned how you can leverage Microsoft Excel to
analyze the data stored in Microsoft SQL Server.
The process of using Excel to analyze the data stored in SQL Server involves creating data-
base objects, such as views, to present the data in a reusable format as well as configuring
database user roles and permissions.
