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
 General SQL Server Forums
 New to SQL Server Programming
 how to use bcp for importing data frm text & excel

Author  Topic 

Ronesh
Starting Member

33 Posts

Posted - 2009-09-16 : 04:49:46
Dear all,

i need to insert data from text file and excel file to sql server tables.
i look around for bcp utility.
can any one give me suggestion how to use this very exe?
i studied all its parameters.
what to do with the case while the text delimeters are comma,tab,|,\,etc.?
what format file is actually and similarly data file? i saw this word in almost very page i googled.

help me please.

Looking forward for the positive response.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-09-16 : 04:56:49
Hi

Refer

http://msdn.microsoft.com/en-us/library/aa174646
http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell
http://blogs.techrepublic.com.com/datacenter/?p=319



-------------------------
R...
Go to Top of Page

Ronesh
Starting Member

33 Posts

Posted - 2009-09-16 : 05:09:40
Thanks.
i will look.
Go to Top of Page
   

- Advertisement -