Collections:
Defining Excel Files as the DTS Data Destination
How To Define Excel Files as the DTS Data Destination?
✍: Guest
Microsoft Excel is a nice tool to view and manage data in rows and columns. If you have a small database table, you may want to export its data to an Excel file so that you can make changes easily. This tutorial is a continuation of the previous tutorial to define an Excel file as the DTS data destination.
1. Continue from the previous tutorial until you see the data destination window.
Select "Microsoft Excel 97-2000" as the data destination driver. Then fill the other fields with:
File name: C:\temp\fyi_links.xls
2. Click Next. If you see the data selection option window shows up, your data destination is defined correctly now. You are ready to continue with the next tutorial to define data selection options.
⇒ Copying a Table from Source to Destination
⇐ Defining SQL Server 2005 as the DTS Data Source
⇑ SQL Server FAQs - Introduction to DTS (Data Transformation Services)
2024-01-31, 1264🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...