SQLTeam.com | Weblogs | Forums

Import CSV with decimals

I'm using SSMS to import a csv file into a table in my SQL database. I am having trouble with the decimal columns, but mainly the ones that have 2 digits before the decimal point.
i.e. seems to like figures like 1.3566 but fails on ones like 14.6566.
I have tried setting the field to numeric(18,10) and decimal(18,10) but it fails. It also fails if I keep the field as string?
Any help would be appreciated.

Are you using import flat file wizard?

Thanks for your reply. I am using the flat file import wizard

Are you able to see correct data in preview?

Preview brings up the correct information, but when I go through to the end and click Finish it then fails

can you show us the error?