Automatic data type detection

Hi experts!  I have access to a Source that has multiple column, all of them declared as text. it doesn't matter if there is a date, numbers etc - the source declared everything as a text. We are ...