Problem with number in CSV file

[huyhk]

Hi all,
I have a problem with numeric values when importing data from a CSV file
This is my code

   oCnn.ConnectionString = "Provider=Microsoft.Jet" _
            & ".OLEDB.4.0;Data Source=" & path _
            & ";Extended Properties='text;HDR=YES;" _
            & "FMT=Delimited'"

    Set oRs = oCnn.Execute("select s.* from [" & filename & "] s")

This is my CSV file

    Code,Quantity (header row)
    "A","1"
    "B","2"
    "C","3"
    "D","1,000"

After running above code, the quantity value of row 4 is null. But if i have only row 4 in my CSV file, the quantity value will be 1000. I dont knnow how to resolve this problem.Anyone can help me?