>Hi,
>
>I'm using the function bcp to transfer data from my table to a data file. When I use it at the dos command prompt, no problem everything works really well.
>
>But if I use query analyser I have an error: unable to open bcp host data-file.
>
>Here's the line:
>xp_cmdshell 'bcp table.owner.inventaire out c:\1\test.txt'
>
>The problem is not with xp_cmdshell because I can call simpler executables in query analyser.
>
>
>Thanks again!
>-Mic

---

When you run bcp at the dos command prompt it runs on a workstation.
With xp_cmdshell in query analyser it runs on SQL Server machine.
I guess you don't have subdirectory c:\1\ on it.