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 Administration (2000)
 BCP

Author  Topic 

cbeganesh
Posting Yak Master

105 Posts

Posted - 2008-10-02 : 15:31:11
hi
Im trying to load a file using bcp . This file has text qualifier and is comma seperated.
Any help with sytax

MASTER.DBO.xp_cmdshell 'bcp "dbname.dbo.tablename" in "L:\234.csv"
-StestServer -c -t, -q"'

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-02 : 15:42:41
-t","



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-02 : 16:01:13
You don't need double quotes around -t or any of the parameters.

You probably need to specify your row delimiter via the -r switch.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -