Insert SQL table into AS400 Alias

I have a SQL 2000 table that I want to insert into an AS400 alias. The 400 is a linked server to SQL. I can insert 1 record at a time with Insert OpenQuery.

insert openquery(AS400bck, 'select * from netfil.sp')
VALUES(1,6,2493,1,30,180,1,-8.00,0,-100.00,0,0,30,180,180,'',2,'X','','')

One of the tables is quite large so I don't want to have to use the values clause.

How can I insert the entire table at once?

Does this work?

I only have read only access to my AS400 environment...

insert openquery(AS400bck, 'select * from netfil.sp')
select [columns] from table where xxx=yyy
|||The statement did work correctly. Thanks for your help.