Type Mismatch and Avoid Duplicacy

Feb 18, 2010 at 6:45 PM


I like the tool and test with 500 records successfully. Kudos to you.

I have two questions

1. I have spreadhsheet with date column. SOme of the record have dont date value. It wont allowing me to insert the record giving Type Mismatch( checked with empty value as well as NULL value both). How can I get rid of this?

2. Is there any way that we can eliminate duplicate records?

Please advise.