Importing relational data from Excel 1

[MrPink1138]

I have a spreadsheet given to me by a client which contains 2 workbooks.

1 for publications (Washington Post, NY Times, Associated Press, etc)
1 for journalists with their associated publication. So the data would be 2 columns and look like:
Bob Jones, Washington Post
John Smith, NY Times
etc, etc.

I want to import the publications workbook... piece of cake. My identity column gives each publication a unique ID.

Now.. the tricky part. I want to import the journalists workbook and have it lookup and use the newly generated unique IDs for each publication.
Does anyone have any ideas on an easy way to do that??

Thanks in advance.
Jason

 

[JamesLean]

One way would be to import the list "as is" to a staging table, then copy it to the master table, joining to the publications table to get the id.

--James

 

[MrPink1138]

For some reason I thought it would be more complex than that. That works great. Thanks!