[AccessD] Updating from Text to Number data type

I'm changing a one-table db over to a relational db.  I have retained old
fields with data so I can update the new look-up fields quickly. 
For example, Hostel records into UnitID via an update query to save doing
hundreds by hand. 

Only ... UnitID becomes a Number data type, and Access2K won't let the data
be moved across. 

Be most grateful for a nod in the right direction. 

All the best
paul 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.1 - Release Date: 13/06/2005