I have a MS SQL 2005 database, however one of the tables has old data in it which I want replaced.
I have a .BAK file that was created a week ago, which has the correct data in this particular table, and I want the data from this table in the BAK file to replace the same table in the current database.
I cant just do a full table because there is other information in other tables in the BAK file which is old.
How can I do this? I am thinking if I could just export then import the data from this table, but dont know how to do this. I am used to MYSQL, and know this can be done easily using phpmyadmin.
Any help would be great.