Contact using Excel and SQL Server

This article is based on two software ――sql Server and Excel. This article will help you understand how to seamlessly connect the two software to the output of the data. In this way, the reports and information you provide will help them work more efficiently and reduce the frequency of users ' recourse to the corporate DBA.

Today, many companies use SQL Server to process data about products, services, and support-all the data that you can imagine. Typically, companies that have SQL Server installed have both large and expensive software applications that are used to insert and locate data from the database. How to generate a report is a problem when these applications can actually play a role, and the programs need to import data into SQL Server under different circumstances.

For most users, creating a report of the data in SQL Server is straightforward and obvious. By using simple actions, you can create a document that represents the current SQL Server data to your users, and your users are unaware that the data is stored in a large database and that there is a lot of data to support it. At this point, you can use Excel spreadsheet to display more relevant data, the following is how to do the steps:

Author tips

This article is based on two software ――sql Server and Excel. This article will help you understand how to seamlessly connect the two software to the output of the data. In this way, the reports and information you provide will help them work more efficiently and reduce the frequency of users ' recourse to the corporate DBA.

To express the purpose of this article, I will use the evaluation version of SQL Server 2000 and office XP. At a minimum, you need to install Microsoft's SQL Server run version and Microsoft Excel or office. I will use the Northwind database, which is a database that is included in both SQL Server Standard Edition and Enterprise Edition. This database is also true for Microsoft Access.