[dba-SQLServer] Import data from Excel into SS2K

look in BOL for the transformation object in DTS.


On Mon, 29 Nov 2004 12:12:27 -0800, Ken Stoker
<kens.programming at verizon.net> wrote:
> 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
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!