Errormessage while importing .csv file into Access 2010

[HerrSober]

This is the content of my file testAI.csv

Common Date,Week,Status,Business Unit,Assignee
2014-08-18,2014 Week30,Closed,Tech Rep,Paul Smith,

When I try to import it in Access 2010 I get the error:

"Text file specification field seperator matches decimal seperator or text delimiter"

As suggested from an article from Tabelousoftware
(source: Resolving "Field separator matches decimal separator or text delimiter" Error | Tableau Software )

This is the reason for this error:

These issues can occur when the data source that you are connected to is a comma separated values (CSV) file that was created on an operating system (OS) with an English locale and being accessed on an OS with a non-English locale

I solution for this should be to create a schema.ini file and put it into the same folder as the file I want to import.
I have edited the dateformat to fit my .csv file. But the errormessage still persists.

This is my file schema.ini

[testAI.csv]
ColNameHeader=True
Format=CSVDelimited
DateTimeFormat=yyyy-MM-dd
Col1=A DateTime
Col2=B Text Width 100
Col3=C Text Width 100
Col4=D Long
Col5=E Double

I have never wrote a schema.ini file before and am not (yet) an experienced programmer.

I am therefore kindly asking for your assistance in making the schema.ini file correct,

...or something else that might work.

 

[HerrSober]

Found a fix. Case closed.


Solution:
Changed the regional settings on the computer. Didn't need to make a schema.ini file after that.

Control panel --> Regional and Language --> Formats (the first tab) --> Additional Settings and there I change to:

Decimal symbol: " . "
Digit grouping symbol: " , "
List seperator: " , "

This is the thread that led me to the solution:

CSV with comma or semicolon? - Stack Overflow

Change Regional regional settings:</SPAN>
http://stackoverflow.com/questions/10140999/csv-with-comma-or-semicolon</SPAN>