Use existing assets for a cost-effective solution
Last month, in "Accessing SQL Server Data," I described the first three steps of a six-step process to distribute data views to the user's desktop, using Microsoft Excel as a low-cost front end to your SQL Server. Using the Pubs database as an example, I described how to set up the ODBC connection between Excel and SQL Server so that the views created on the SQL Server would be accessible from Excel. Now let's look at th...