Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating all pivot tables at once | Excel Worksheet Functions | |||
Updating Pivot Tables | Excel Programming | |||
Updating tables! | Excel Worksheet Functions | |||
updating tables automatically | Excel Discussion (Misc queries) | |||
updating pivot tables | Excel Discussion (Misc queries) |