Many times you need to import data from different databases into your SQL Server database. If you do not have SQL Server Enterprise manager or similar tools then it becomes very tedious to import such data. This is especially true when you are working with SQL Server Express Edition or MSDE.

Read here