here is the requirement for the short function in VB6 of importing data from excel to sql by checking some criteria - through visual basic form .
Just create a form with a button to upload data from excel and checking the criteria and if all good adding to an existing SQL table .
One button to upload and view all good data andanother button to append data to SQL table ,
Also I would like to view the data after it imports and view the error records as well.
This is a procedure not a Programme -- Many other future work depends on this proejct
See Attachment too