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, 1271🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...