|Assuming SQL means SQl server the why not do the clean up in SSMS. My standard method was:
Import the data manually into SQL Server. I would load the data into a new table accepting whatever garbage is in the excel file. All data should be converted to strings on the way in.
Create and empty destination table matching your final destination (this is so you can repeat the process)
Write a stored procedure that:
loops each column and cleans and formats the data as required and inserts it into the temp table.
When you are confident the process works then change the destination to the final destination table.
If this works consistently between loads you can then turns the entire process into a Job which can then be launched by your application.
This method does require reasonable T-SQL skills but would also be an excellent learning exercise.
Never underestimate the power of human stupidity -
I'm old. I know stuff - JSOP