Updating a table in access
Now run the qry Update Album Prices query found in the same database (see Figure 1-17).
This action query will take the Purchase Price values from tbl Albums Updated and copy it into the Purchase Price field in tbl Albums for each record where the two Album ID fields match and the price value in tbl Albums is currently null.
Of late, VBA has been disregarded by many software professionals for .
I want them to be able to import the data back into access and run the update queries from the Excel workbook.
I "THINK" what I need is VBA code that will copy the open workbook, reach out to access and paste append the data into a staging table.
You can also include additional fields in the query grid to further limit the rows to be updated.
Drag these additional fields to the query grid and specify criteria for them.