declare @sql        varchar(4000),
        @rowcount   int
--sample query: you would do the same to your existing bcp
set @sql = 'bcp "SELECT TOP 5 * FROM SYSOBJECTS" queryout "c:\body.txt" -c -U"sa" -P"NotARealPassword"' 
--export via bcp
insert into #results
EXEC master..xp_cmdshell  @sql

declare @sql        varchar(4000),
        @rowcount   int
--sample query: you would do the same to your existing bcp

--due to %path% issues, identify the full path to bcp
set @sql = 'C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\bcp.exe "SELECT TOP 5 * FROM SYSOBJECTS" queryout "c:\body.txt" -c -U"sa" -P"NotARealPassword"' 
--export via bcp
insert into #results
EXEC master..xp_cmdshell  @sql