Defining Excel Files as the DTS Data Destination

Q

How To Define Excel Files as the DTS Data Destination?

✍: Guest

A

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)

⇑⇑ SQL Server Connection Tutorials

2024-01-31, 2061🔥, 0💬