Auto Transfer Of Data From One DB To Another

I`m wondering the best way to automate the transfering of data from
one SQL 6.5 DB to another SQl 6.5 DB, both are on the same server.
The idea is to move the data, then purge it from the orginal DB.
I was thinking of using bcp, is there a way to copy a selected group of records
instead of a table (I need to be able to select the data to transfer), or
do I need to select the data to table then use bcp, or is there an better
way to do this?

Thanks,
Nora