I have worked with DTS before, but usually just to import Access dbs to SQL
Server. This time it is different. I have a table for positions
(employment) and when I was hired, this table was incomplete. I have
tracked down the data I need and it is in an Access DB. The source DB was
done by someone who doesn't know much about how databases should be
structured.

The source data has 1 table, with employee info and position info. I need
to get the position data out and import it into my position table.

Here is my source query.... very simple

SELECT DISTINCT posnumber, jobrole, jobtitle
FROM Employees

I need to get this data into an existing table on the SQL Server. The
position number is already entered, so I need to update the Role and Title
fields with the data. Is there anyway to do this...

In other words, PosNum 000003 has a role of Admin and Office Specialist III
and a title of Director's Secretary... The 000003 is already in the
destination db so I need to find that record and insert the role and title
data...

Does this make sense?

Thanks,
Drew