import export table on db server to another in sql

If the two servers are set up as Linked Servers in SQL Server then you can use the fully qualified name.

Insert Into Server1.Database1.dbo.Table1 (Col1, Col2)
Select Col1, Col2 From Server2.Database2.dbo.Table2

For Linked servers http://msdn.microsoft.com/en-us/library/ms190479.aspx[^]
Try this links.. http://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/[^]
http://www.mono-software.com/blog/post/Mono/168/Different-ways-of-importing-data-into-SQL-Server/[^]
http://msdn.microsoft.com/en-us/library/ms190923(v=sql.105).aspx[^]
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]