To elaborate a little :

My current task is to append a csv file (sent by another dept) to existing tables in sql server.

One of the column in the SQL server tables is "Time" and the existing data in these columns are integers .

example : they have values like 34567, 87658

When I look at the design of the table, to view the datatype of the column : It is "float" in some tables and "varchar" in few others. I cant make sense out of this !!!

I am trying to append the columns from the csv file to the columns in sql server table and this is giving me a hiccup!! I am unable to proceed any further

Please help

Thanks