Next Topic

Previous Topic

Book Contents

Excel Usage

Creating a Data Source in Windows

Microsoft Excel can access the views by setting up a data source. A data source is a core definition within Microsoft. Most Microsoft products have facilities to access data through a data source definition. 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).

Selecting the Data Source in Excel

Once a data source is created it can be referenced by Excel. Open a blank spreadsheet and select the Data > Get External Data > New Database Query... option. 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.