Importing Data

[jimd1768]

I am trying to import data from excel. All the data imports perfectly, except the previous Customer ID autonumber is imported as a number and I cannot change it.

Does anyone know if there is a simle solution to this problem.

Thanks in advance

 

[gemma-the-husky]

import to an intermediate table first, then use that to bring it inot your real data tables?