Hi All,
We a requirement to read excel and validate for empty rows , validation of mandatory fields and datatype validations , there are around 15 columns in each row, we have used readexcelsheet function and did the validations.
Now user wants to upload a excel with around 5k rows and due to which our code is throwing 603 error in site .
Could you please let me know the best approach for handling this type of huge data and validations more effectively.
Thanks in advance!!!
Discussion posts and replies are publicly visible
Dump it in a table first and then run a stored procedure to validate the input?
I would second this kind of approach (although I hate with a vengeance embedding business logic in database objects!)