validating imported data

[hemlock]

I am importing Excel data into just a standard inventory database (via Import from a file).

The import works just fine. But I'd like to run some sort of validation when I import so that I can check any errors committed while in Excel; for instance, I have a uniqueness requirement on asset tag numbers that doesn't seem to catch duplicates upon import.

I don't know what the best way to do this would be. If there is a duplicate validation option in Excel that I could use instead, that would be fine.

I would appreciate any suggestions.

Thanks and have a good day!

Bob Lehner

Hemlock Public Schools

Hemlock, MI

[-Queue-]

Validation doesn't run on import. The best way would probably be to loop through your imported records and perform your desired validation tests on each one.

[hemlock]

That's a great idea. Thanks very much! :-)

Bob