Hi All
Looking for help in the below problem
The requirement is to validate a raw csv file after loading into excel sheet. I'm planning to use the approach of excel as database as there are rules based on individual record based on field values (e.g. if field 1 is blank then field 4 must be blank etc) and based on index field some validation to be performed at file level.
* Query 1 - SQL queries used when working 'Excel as Database' is same as SQL Server SQL ?
* Query 2 - If validation fails for any fields, i want to highlight them in different color ? Is this possible when we using 'Excel as Database', by update recordset ?
thanks in advance
Looking for help in the below problem
The requirement is to validate a raw csv file after loading into excel sheet. I'm planning to use the approach of excel as database as there are rules based on individual record based on field values (e.g. if field 1 is blank then field 4 must be blank etc) and based on index field some validation to be performed at file level.
* Query 1 - SQL queries used when working 'Excel as Database' is same as SQL Server SQL ?
* Query 2 - If validation fails for any fields, i want to highlight them in different color ? Is this possible when we using 'Excel as Database', by update recordset ?
thanks in advance