Excel into SQL Server, type conversion

Server SQL Server Excel data type conversion to ask you: 

I use SQL Server task, is that the data from the Excel into the SQL Server table in the database. Said in the database has been built, each field is also the good. 

And then I found in the process of pilot data,: Excel data types from the Float cannot be converted to the data in table Int type; Datetime type in Excel cannot be converted to the table in the database of Date type.. Then is to guide data error. . 

Here mainly to ask the solutions you.... A database table data type can not be changed, my attempt is to have all the Text type in Excel, or the results of the two type conversion out wrong. .  

13 different outdoor locations for Google Street View.

Started by Alexis Gross at January 29, 2019 - 8:08 PM