Newb, validating data as it is imported

[Bakta]

Hi,

I have to import an excel file which contains fields I know will have to be reformatted/modified, e.g phone field which contains national code which has to be deleted.

I figured out how to modify the relevant fields, but for the life of me cannot find how to make it so imported data is modified on the fly.

thx for your help

B

 

[FoFa]

Typically I will import the data into an IMPORT table, then use queries to reformat and move the data to it's final resting place.