Ken Stoker
kens.programming at verizon.net
Mon Nov 29 16:29:45 CST 2004
Thank you. I wasn't using the right keywords in BOL. Really helps when you have a clue what you are looking for. Ken -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Monday, November 29, 2004 2:05 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [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! _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.3 - Release Date: 11/26/2004 -- 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