Next Topic

Previous Topic

Book Contents

Excel Usage

Microsoft Excel can access the views by setting up a data source.  Selecting the Settings option from the Start button allows the creation a data source. From the Settings option select the Control Panel.  From the Control Panel next select Administrative Tools.  From this menu a data source can be created.

The data source should be set up as a System DSN.  From this dialog, create a source using the SQL Server driver.  The set-up will require the name of the database server (usually the ComputerName), the user id (KaseyaViews) and password, and the database schema name (ksubscribers).

Once a data source is created it can be referenced by Excel.  Selecting Get External Data from the Data menu does this.  A new database query can be started from this selection.  The user is prompted for the credentials to the database.  Once this completes a view can be selected.  A SQL query can be constructed to bring information directly into Excel at this point.

A data source is a core definition within Microsoft.  Most Microsoft products have facilities to access data through a data source definition.