Importing a complete table into another sql db

I need to import a complete table, with data from one sql 2008 database into another. I looked at Import and Export function, but cant see how the table definitions can be imported.


If the target database does not have the table defined, the wizard will build a CREATE TABLE statement.

I sometimes just pretend I'm an idiot (not far from the truth!) and click my way through to see what happens.

yes, that worked fine, created the table

and the advice about clicking is priceless :+1:

Thank you