Exporting Data

Guys,

I'm trying to export data from SQL. Can anyone help. I have commented my script below and have managed to create a table, insert using 'bulk insert' - now I want to export the data out. I'm getting an error message saying 'cannot use the output option when passing to a stored procedure'.

comment
-----------
drop table for re-runs !
-----------

drop table JET
go

comment
------------
create a table to match the .txt file importing
----------

create table JET
( [USER] char( 25),
[DESC] char (20),
SYSDATE datetime,
SYSVALUE MONEY ,
POSTDATE datetime,
POSTVALUE MONEY,
GLCODE CHAR (20)
)

comment
---------------
import using pipe delimited .txt file
--------------

bulk insert JET from 'D:Documents and SettingsmpeetSQL Test.txt'
with
(
fieldterminator = '|',
firstrow = 2
)

comment
-------
check results
-------

select *
from JET


NEW BATCH

bcp JET out 'D:Documents and SettingsmpeetSQL Testexport.txt'

I want extract the data to a .txt file would anyone know the syntax?

Cheers

Michael