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, 1336🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...