Importing files with a mix of decimal separators Using SQL Server Management Studio 18.3 I want to import data (semicolon separated text file) that has some columns with dot as decimal separator, and some with comma as decimal separator. I can't find an option to import both types on the fly, forcing me to choose nvarchar for either of them, and then transform it. Changing locale first would not help either, obviously. (I find it odd that the import wizard is not locale-agnostic.) How do you best resolve this problem?
Maybe you can try to edit (with notepad++) the file before import and clean (with a carefull find and replace) the separator you don't like.