Error while importing through wizzard a CSV file

Question

Hello!

I am having trouble while importing .csv file. It gives the same error. Please help me:

Why does it see all cell values as string ? All values in my cells are floats.

✗ Microsoft.SqlServer.Prose.Import.BcpProcessException: Error inserting data into table.
---> System.InvalidOperationException: The given value '0.0' of type String from the data source cannot be converted to type float for Column 5 [new_cases].
---> System.FormatException: Failed to convert parameter value from a String to a Double.
---> System.FormatException: The input string '0.0' was not in a correct format.

Answer 1

Hi @Helen

Why does it see all cell values as string

The data in csv file is text and does not have the format of float.

You may try to use SSIS to load the csv to sql server table which will be more convenient.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Why does it see all cell values as string ? All values in my cells are floats.

A CSV is a comma-separated-values text (!) file; everything is text until you define a different data type. In Wizard click on "Column mapping" and define different data types.

Answer 3

What are you regional settings? In many regional settings the decimal delimiter is the comma. I don't use the wizard a lot, but I don't think there is a way to set the delimiter. You may have to change your regional settings in order to import the file.