Microsoft SQL Server 2000 provides the Data Transfer Service (DTS) tool to streamline the task of moving data between disparate systems. It's available as a tool in the SQL Server Enterprise Manager client interface. In this article, author Tony Patten take a closer look at how to access and use DTS by exporting data from SQL Server to an Excel spreadsheet.
The complete article is available at
Back to Database Journal Home