I have done a task of Importing excel in SQL server 2000 using Vb.Net 2003. I have provided Import/Overwrite facility to the User here. For this i used a Combobox. I have inserted values in Combo at design time. From the Property, Items (Collection). In Code i checked the Combobox.text. If it is Overwrite then i done Update else Insert.
My problem is Its running fine some time and some time insted of Overwrite its doing both the tasks. Overwrite and Import. I am unable to fine the problem. Can any one help/guide me. Where can be the problem. If needed i will put my logic here. Let me know for it.