Best way to Modify all (or batch) items within a table(s) inside local Access database...Excel?
Posted on 2014-10-19
With a local Access database, what is the best way to make > 100 modifications to one or more tables?
Example: 30 minutes needs to be added to each entry within a particular table.
Example: A new column needs to added and values placed in each field based up the value in another field.
Example: Comparing field values in one table, and verifying the value (or name) exists within another table.
Each table within the database has less than 15,000 records.
Is using Excel the best option? If so how would that be done?