>Hi all
>
>I am looking for a XLS to MSSQL data import tool that has data validation capabilities as follows
>
>1. Range Value check
>2. Fixed Values check
>3. Referential integrity check
>4. Data truncation if source data too wide to fit
>
>This far, all the XLS data converter that I found does not provide data validation.
>
>Your advice is much appreciated
>
>Thanks & Best Regards
>
>Thanks

I would do this that way:
Create an SSIS package that will import XLS file into new table (with predefined name).
Then after the import run SP that will do all validations you want.