a little help with transfering table A in Database A into table B in database B

I can't seem to find a good tutorial in transfering data from one table in database a into a different table in database b. The catch is that the fields in the tables don't match exactly.

How can I do this? Examples, tutorials, etc are greatly appreciated.

Thanks!

All you need is INSERT INTO with column list that will give you control of how you the the insert into the new database, the other option was to use DTS. Try the link below for the INSERT INTO statement. Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_5cl0.asp