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)
 import file into a table

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2006-11-29 : 09:00:59
i have files which i want to import as is
how can i do it withough using the master..xp_cmdshell Stored Procedure?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-29 : 09:03:23
Make use of BCP utility.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2006-11-30 : 04:55:07
i have searched all around and the BCP always used the cmd_shell SP which i cant use-any alternative?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page
   

- Advertisement -