I have a access database that has a column that I need to port over to a sql server 2008 database. The tables that have this column / field are different but do have some similarities in that one of the fields is populated with a unique identifier. The thrust of is effort is to associate a photo with an individual. Both SQL and access have fname, lname and picture/photo but access only has the photo populated. I would like to populate the SQL picture column from the access database and of course associate it with the correct name. Suggestions on how best to accomplish this would be extremely valuable and appreciated.

Thanks