I have an Excel file which updates daily. I need to move the data from Excel into a SQL Server table.

I can do it from data import in SQL Server. But the question here is the same Excel files updates daily. Sometimes the data might be wrongly inserted under the columns.

How can I validate the data before importing? How I can import without changing the datatypes? How I can automate this process?

Thanks in advance