Once you have figured out the connection issue (see my response to your other post), the easiest way for you to initially do this is with DTS. If you can make a connection, the DTS Import/Export routines can take care of most of this for you. I'm not currently at a system where I can bring up Enterprise Manager, but you might take a look in Books Online (the documentation that ships with SQL Server). If you don't have it, you can either use the version that's up on MSDN (http://msdn.microsoft.com/library/) or download it from here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley