Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 data from excel to sql server

Author  Topic 

simonchia
Starting Member

11 Posts

Posted - 2004-06-23 : 08:37:24
greetings all,
i need to transfer data from an excel sheet to sqlserver. i know dts can be used to acomplise this task but due to business requirements we are not allow to used such method. how can i code it in t-sql for such a task? thanks

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-06-23 : 08:41:04
Check out Regan's (Wanderer's) code toward the end of this post - http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=36383
It is probably doing something similar to what you want :)

EDIT: Oops I mean enigma's code.

Duane.
Go to Top of Page

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2004-06-23 : 10:15:46
new version of code at the bottom (my code :-))

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -