The Excel and SQL Server experts blog

When users input new values into Excel cells, each entry is instantly validated against the data type of the mapped SQL Server column.

Lookups of texts for key values in related tables allows end-users to easily work with relational data, while keeping data integrity.