Updating tables in Access
I have approximately 100 Access databases (one for each cost center). Each
cost center has their own folder on a corporate drive. There are 3 other files (Excel) besides the database in each folder. I have a macro that will cycle through all of the folders and replace any of the 3 Excel files in each folder. I now need to update 2 fields ("Office", "CostCenter") in a single table. This table only has the 2 fields and each field has a text string of "4.0". I need to update each field with "5.0". I'm trying to create a sql statement that will update /replace each field with "5.0" The database name is "MyDatabase". The table name is "Version". The field names are "Office" and "CostCenter". Any help getting started would be greatly appreciated. Thanks....... -- JT |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com