I need to update the addresses in a Sage300 table. I have the addresses in excel. I can pull in the table from Sage through Access and pull in the excel sheet with the corrected addresses. Once I click query and then update, how do I setup the info in the query to look at each key and update the address from the excel to the table?
I thought I would bring in the table and the excel and link the keys, then in the field area I would put in the fields that I want to update from the table. In the update to I would put the excel fields that have the correct info and click run. This changed all data to the same info. Example:
Field - table.address1
Update to - excel.address1
I thought this would update all the address1 info from excel and based on the key being the same it would update table.address1