title: Create a new lookup table where data already exists
body: <p>I am working on a database in MS Access 2013 which has a considerable amount of non-normalised data, and I want to move them out to alternate tables and use them as lookups in the main table. However, when I create a lookup column, MS Access deletes the data and there is far too much data to reset every record by hand.</p>
  
  <p>Is there a way in Access 2013 to create such a lookup without losing the data?</p>
  
  <p>Please don't comment about how using lookup tables in Access is bad. I have read posts like the one below and I disagree with most of the points there, and some of them are just simply wrong.</p>
  
  <p><a href="http://access.mvps.org/access/lookupfields.htm" rel="nofollow noreferrer">http://access.mvps.org/access/lookupfields.htm</a></p>
  
  <p>Below is a sample of my data. I need to extract the 2nd and 3rd fields to other tables. If I can do this with them, I can do it with the others.</p>
  
  <p><img src="https://i.stack.imgur.com/1DRVV.jpg" alt="enter image description here"></p>
  
  <p>Presently this is stored as text in the fields. I would like to remove them and replace them with FK id's.</p>