dear saviours out there..
I have created a form to import excel data into my database table - its perfectly working
I have set a condition for my database table column - Eg. Tagnumber should not be null value
when I upload the excel file - the records where Tagnumber is empty -doesnot get uploaded - this is ok,but Im not aware or informed about this missing records due to null value
So my idea is can we generate a kind of error report ( or a error table that MSacess generates for a type mismatch error sometimes) with the source or rows containing the error values?
your help appreciated.
I have created a form to import excel data into my database table - its perfectly working
I have set a condition for my database table column - Eg. Tagnumber should not be null value
when I upload the excel file - the records where Tagnumber is empty -doesnot get uploaded - this is ok,but Im not aware or informed about this missing records due to null value
So my idea is can we generate a kind of error report ( or a error table that MSacess generates for a type mismatch error sometimes) with the source or rows containing the error values?
your help appreciated.