Yep,you are right.

But in that case, if first 10 rows are integer then we might have to hardcode some sample values in the first row so that table will be created with the desired data types.

any other alternative way to overcome this hardcode....??