Update fields using a field trigger

[G4Stech]

I don't know if this has been discussed here before or if this is the correct topic so please bear with me.



I have two excel spread sheets I would like to merge into a single database. I have imported the primary spreadsheet into Access as a database and now would like to update selected fields from the second spreadsheet. They are both parts lists that have simillar data and I only want to change some fields, like description and price, using a common trigger.

During the second spreadsheet import if part number 1001-01 is found in the database change the description field and price field to the value of the spreadsheet and flag the record that the data has been changed. Then, if the part number is not found, import the entire record into the database.

I'm sure this can be done but I have never done it before.

Thanks for your help.

[June7]

Options:

1. link to second spreadsheet
Execute two SQL actions, - an UPDATE and an INSERT SELECT
The UPDATE would involve an INNER JOIN of the two datasets.
The INSERT would involve a Find Unmatched query to identify records in table 2 that are not in the primary.

3. complex VBA code

[G4Stech]

June7 thanks for the information however I think I'm in over my head. I'm able to do step1 after that I can't figure out how to even get to SQL much less run an UPDATE or INSERT SELECT. If I click Visual Basic everything is grayed out and there is nothing in the header bar that mentions SQL but the icon to move the data to an SQL Server.

Unless someone is willing to tell me where to go from here to do this I guess I'll have to accept defeat and move on. Thanks again.

[June7]

SQL is the language of queries (Structured Query Language). Use the Access query builder. Access Help has guidelines on using.