Script to copy table between databases

From: newbie (anonymous_at_discussions.microsoft.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 12:11:05 -0800

I'm trying to write/find a script that will copy all data from a table in database1 to the same table in database2. The databases are on the same server and the destination table already exists and is identical in design. I need to overwrite the destination table data if it already exists.

Thanks