<div>
Ok I will look at that. What it did was update all the address to the same address.
</div>


Ok I will look at that. What it did was update all the address to the same address.

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
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:<br />
Field - table.address1<br />
Update to - excel.address1<br />
<br />
I thought this would update all the address1 info from excel and based on the key being the same it would update table.address1
</div>
</div>


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

Update Table in Sage300 (Timberline) in Access from Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.