Oo I see, thanks!

Hi Steve, thanks for the heads up, but my import is from Excel to SQL so this should not be an issue. Thanks anyway!

Thanks, I replaced the VALUES with a SELECT statement on my column that contains the original data. 

The output is a column with all the converted values. I will...

Hi Thom,

The column was initially varchar(50), but I changed it now to datetime. Some examples of the data:

Excel        = SQL Server
744:00:00 = 1900-01-31...

Hi Steve, unfortunately I can not change the format manually as there are hundreds of these sheets sent each month. The goal is to automate the process as much as...

Thanks once again Steve. Fortunately I have more experience with Visual Basic than SQL so that was not to difficult (with the help of Google of course). I marked your...

Thank you sgmunson for clearing that up. 

I have written...