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?