[SOLVED] Customer CSV import error

Hi
This may just be me being blind but I can't see whats wrong with my CSV import file.
I get this error
SQLSTATE[HY000]: General error: 1364 Field 'name' doesn't have a default value

Here is the first 2 lines of the CSV.
id,customer name,type of customer,customer code,payment deadline,tax,tax number,closed,description,designation,street,complement,zip code,city,state,country
1,EDS,98,EDS,,,,,,Our address,Our Road,Our town,,Our city,Our State,UK

anyone with any ideas, most appreciated...

Thanks for the support babynus, I have already tried with codes and/or captions getting the same result each time.
I tried again with codes, just in case but no luck, It looks like a simple CSV I must be missing something...

I still get the error "SQLSTATE[HY000]: General error: 1364 Field 'name' doesn't have a default value" but it looks like there is a value in the file, very odd...

Hi Babynus
I've tried creating dos/mac csv, I've created a 2 line file by hand in notepad++, I cant think that it is actually the CSV that is causing the problem.
This is what I used:

id,name,idClientType,clientCode,idPaymentDelay,taxPct,numTax,idle,description,designation,street,complement,zip,city,state,country
1,EDS,98,EDS001,,,,,,Waterside BP,16XX Perhshore,Kings Norton,,Birmingham,WM,UK

Still comes back with:
SQLSTATE[HY000]: General error: 1364 Field 'name' doesn't have a default value

Could it be a bug/regression in version 5.1.4?