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, 1242🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...