use tempdb

create table playertemp

( playerID varchar(25),

playerFname varchar(25),

playerLname varchar(25),

email varchar(25))

insert into playertemp

select * from test.dbo.player  //just use your query over here

and then

bcp tempdb.dbo.playertemp out "c:\playertemp.txt" -c -T -SKalopoolbasi

note Kalopoolbasi is the server name

This should work.