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.