Unanswered: populating sql 2005 server from another db
I am a complete noob when it comes to sql server. I was wondering if any of you can point me to some tutorials showing how to populate a database in sql 2005. I have used myphpadmin and sqlyog before to insert thru a txt file. But I can't seem to find and option in Microsoft sql server management studio express. I'm some what familiar with mysql, but only thru gui interfaces.
I have one database that collects user information from one site, and I want to insert that information into my new sql server database. The new db has more columns than the user db so I only want to put in certain columns into the new db.