1.I already used try/catch block it cannot catch this exception.
2. Actually data is inserted by a window application designed in vb6 with ms access as backend. I cannot change that application becuase it's not mine. All i have to do is to copy data from ms access to centralised sql server and make reports only.
3. I only want to copy rows which wont contain any data value #error