[dba-SQLServer] Import data from Excel into SS2K

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
 




More information about the dba-SQLServer mailing list