Your numbers have me spinning a little. It looks like your Case 3, and Case 5 are the same, but since that would make no sense, I assume that in case 3 there are really 1002 records with one being the header? If that's true then the only thing that stands out at all is the combination of the 1000th and 10001st record in case #3 (not counting the header). Try using that combination of rows in another scenario. Try using 3 records including the header and make record 1 the original 2nd last record from test 3 and the last record from test 3. It might not mean anything, but if there is something at the end of the 2nd last record that is confusing Fox, it might crash when it gets to the last record making it look like the last record is the problem when it isn't.

I hope you liked your visit to Markham and Toronto. Markham is a very nice town nicely buffered from the real Toronto by what used to be Scarborough. Where did you go in Toronto. Maybe I saw you on the street, or in a restaurant. ;)

Alan

>Hi Alan,
>
>Thanks for your reply.
>
>I checked with my excel file. You are right, but I am not sure if there is anything wrong with my data.
>
>Here are some of the tests I have made:
>
>Case 1: 10002 records, all are unique --> Fail to import
>Case 2: 10001 records, all are unique --> Successfully imported
>Case 3: 10001 records, all are unique and with the original 10001st record replaced with original 10002nd record --> Failt to import
>
>It looks like the original 10002 nd record got problem. So I made another tests
>
>Case 4: 2 records, one header (same as the previous 3 tests) and the original 10002 nd record. --> Successfully imported
>
>Case 5: 10001 records, one header (same as the previous 3 tests) and ten thousand original 10002nd record --> Successfully imported
>
>
>Errr.... i couldn't really draw any conclusion from these tests. Oh.. one more thing to mentioned, my xls contains non-english characters. Would it affect the result?
>
>Regards,
>Chris Hui
>
>ps. Oh, by the way, I was in Toronto too. I was in Markham 2 years ago.