How to import tables from other database

Hi there,

I am having difficulties in importing table from one sql server database file to another sql server database file.

A few months ago, I converted access file to ms sql express file. I had made many changes on the ms sql express file, however, the data in this file isn't the latest as the old system is still being used. Now, I want to deploy my new system, I need to import in necessary tables from the old system database, as well as, I want to retain the tables and data I created on the ms sql express file that I have been using so far for development and testing.

May I know how to import tables from other database? Just as in ms access where we can import tables from other access file. I'm using sql express 2005 and sql server management tool. Any advice/help is very much appreciated.

Thanks...

import you Access data to another database on the server and next write T-SQL statement which will move data from old structure to your new structure. If you have access to full SQL server version you can also try SQL SSIS import package but I think that T-SQL is more flexible in this case.|||

u can use this scripter ... http://www.sqlscripter.com/

using this u can create T-SQL ...