The process of updating data from one table to another follows these broad steps: The steps in this section assume the use of two similar tables.In this example, the Clients table is located in a database that you just inherited, and it contains more recent data than the Customers table.
If the original value is in the form of a valid Internet Protocol (IP) address (four number triplets separated by a period: nnn.nnn) and the numbers happen to coincide with a Web address, the conversion results in a valid link.
Otherwise, Access appends to the beginning of each value, and the resulting links are not valid.
In some cases, the conversion process might delete some data.
For more information about restrictions when you convert data types, see the section Restrictions on data type conversions.
Values must not exceed (or fall below) the size limit set for the field.