I have a table that contains one field that MUST be 9 digits exactly.
I usually import this data from excel and rename the new table to be the one I need.
Is there a way that I can either:
Import data from excel and then do a check on this field for errors or
If I keep the table stucture and import the new data into this table, a way I can require the field to be 9 digits and error out those that are not?
Thanks
I usually import this data from excel and rename the new table to be the one I need.
Is there a way that I can either:
Import data from excel and then do a check on this field for errors or
If I keep the table stucture and import the new data into this table, a way I can require the field to be 9 digits and error out those that are not?
Thanks