Error converting data types when importing from Excel to SQL Server 2008

by

SSIS doesn’t implicitly convert data types, so you need to do it explicitly. The Excel connection manager can only handle a few data types and it tries to make a best guess based on the first few rows of the file. This is fully documented in the SSIS documentation.

You have several options:

  • Change your destination data type to float
  • Load to a ‘staging’ table with data type float using the Import Wizard and then INSERT into the real destination table using CAST or CONVERT to convert the data
  • Create an SSIS package and use the Data Conversion transformation to convert the data

You might also want to note the comments in the Import Wizard documentation about data type mappings.

More Related Contents:

  1. How to split a comma-separated value to columns
  2. Using T-SQL, return nth delimited element from a string
  3. How to get a float result by dividing two integer values using T-SQL?
  4. Get first day of week in SQL Server
  5. How to add Active Directory user group as login in SQL Server
  6. SQL Server add auto increment primary key to existing table
  7. How to delete large data of table in SQL without log?
  8. Confused about UPDLOCK, HOLDLOCK
  9. Retrieve column definition for stored procedure result set
  10. Change Notification with Sql Server 2008
  11. Do while loop in SQL Server 2008
  12. Query times out when executed from web, but super-fast when executed from SSMS
  13. TSQL: How to convert local time to UTC? (SQL Server 2008)
  14. Regular Expressions in SQL Server servers?
  15. Unique constraint on multiple columns
  16. Transpose rows and columns with no aggregate
  17. How to find the port for MS SQL Server 2008?
  18. Should every User Table have a Clustered Index?
  19. Drop primary key using script in SQL Server database [duplicate]
  20. How to convert number of minutes to hh:mm format in TSQL?
  21. SQL Server Configuration Manager cannot be found
  22. SQL Server recursive query
  23. Temporarily disable all foreign key constraints
  24. How do I move a table into a schema in T-SQL
  25. nvarchar(max) vs NText
  26. How to display two digits after decimal point in SQL Server
  27. The request failed or the service did not respond in a timely fashion?
  28. Find broken objects in SQL Server
  29. How to choose the clustered index in SQL Server?
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment