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.

Can anyone point me into a good direction?

Thanks for the help!