[dba-SQLServer] Import data from Excel into SS2K

Using a DTS package, how would I import data from an Excel file into SS2K?
I can create a connection object for the destination database and the
location of the Excel files, but am not seeing how I would then move the
data.  Any help is greatly appreciated.

 

Thanks.

 

Ken

 

 

 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.3 - Release Date: 11/26/2004