copy a table with its data from a db to another

Hi:

At the moment, I know how to copy a db to another (create a .bak file), but I am not sure what is the best way to copy one the table (with it data) from a db to another.

Would u please give some links or suggestions?

Thanks.

jt

You can use Import/export facility available with sql server

|||

Use import and export methods

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you.

|||

You can use DTS Package ( for SQL 2000 ) or SSIS ( for SQL 2005 ).

|||

just do :

Select *

INTO [DESTDatabase].dbo.[DestTable]

from [sourceDatabase].dbo.[sourcetable]

You will have data and structure copied, you only have to setup your constraints (keys, indexes)