TABLE TO TABLE UPDATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access 2003 database. I will be bringing in and Excel 2003 value
but the column a is key or needs to remain the same with the same data in
table and column b will change when inventory is changed and I need to be
able to import in just the column b changes and have them correspond to
column a.
 
You need to import the Excel spreadsheet into another new table. Call it
Inventory_Update.. Then use an update query to change the records as needed
in tyou original inventory table. The SQL would look something like:

UPDATE Inventory
INNER JOIN Inventory_Update ON Inventory.A = Inventory_Update.A
SET Inventory.B = [Inventory_Update]!;
 
Back
Top