I have a front end ACCESS program that transfers a table to SQL server and then based on the table values it has to update multiple tables. The multiple tables' names are based off of a field value in this transferred table , hence the need for a cursor to locate the table names and then a nested cursor to actually update that table. Does that make sense ? Is there any better way to do this ?
Any help will be appreciated.