bcp dbname..testload in c:\"cnet Reports"\abc.txt -T -r \n -S SERV

Hello
bcp dbname..testload in c:\"cnet Reports"\abc.txt -T -r \n -S SERVERA
Since dir has a space (i.e name of the dir is 2 words with a space between
them)
C:\cnet reports
Tried C:\"cnet reports"\
c:\'cnet reports'\
gives error
How to specify a dir that has a space in it
works OK if dir does NOT have a space.
Thanks
Basheerbcp pubs.dbo.authors in "c:\cnet Reports\abc.txt -T -r \n -S SERV"
Quotes around the whole path.
"Basheer" <Basheer@.discussions.microsoft.com> wrote in message
news:9F87DA0B-1BC6-4A07-97C7-F0F99DB0EE63@.microsoft.com...
> Hello
> bcp dbname..testload in c:\"cnet Reports"\abc.txt -T -r \n -S SERVERA
> Since dir has a space (i.e name of the dir is 2 words with a space between
> them)
> C:\cnet reports
> Tried C:\"cnet reports"\
> c:\'cnet reports'\
> gives error
> How to specify a dir that has a space in it
> works OK if dir does NOT have a space.
> Thanks
> Basheer
>|||Hi,
Use the double quotes till the end of file name.
BCP MASTER..SYSOBJECTS OUT "C:\HARI
F1\HARI.TX" -Uuser -Ppassword -SServername -c
Thanks
Hari
SQL Server MVP
"Basheer" <Basheer@.discussions.microsoft.com> wrote in message
news:9F87DA0B-1BC6-4A07-97C7-F0F99DB0EE63@.microsoft.com...
> Hello
> bcp dbname..testload in c:\"cnet Reports"\abc.txt -T -r \n -S SERVERA
> Since dir has a space (i.e name of the dir is 2 words with a space between
> them)
> C:\cnet reports
> Tried C:\"cnet reports"\
> c:\'cnet reports'\
> gives error
> How to specify a dir that has a space in it
> works OK if dir does NOT have a space.
> Thanks
> Basheer
>