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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only