Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to display a SQL Server database report in Excel?

April 26, 2017database display Excel report SQL Server

0

0 Posted

How to display a SQL Server database report in Excel?

1 Answer

0

0 Posted

We are working with SQL Server 2000 Enterprise Edition. We have been tasked with developing a report from the SQL Server database, which we then have to display in Excel. This data will be calculated using a query and then placed into specific cells of the Excel workbook for calculation and graphs. Should we use Visual Basic or does this involve other services provided with SQL 2000? You can use DTS and SQL Server 2000 to transfer data directly to Excel by specifying Excel as your destination end in the data pump. You should consider looking at the Microsoft knowledge base article: “HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation Services” for some details.