Update Master Table Baesd on Slave Table

[alexbeatle]

Good day!

I'm Access 2010 newbie. I need to transfer Excel program into Access.
I have a .csv file (data extracted from emails) and a Master Excel sheet. Master Excel fields are updated from the .csv - if the primary keys match, else the new records are added.
Also, the .csv contains colour names, which must be translated into corresponding peoples' names.
Could you please guide me in the direction I need to do this project.
Thank you.

 

[JHB]

Do you want to import the data directly from the .csv file into MS-Access or import the data from Excel?

 

[alexbeatle]

Do you want to import the data directly from the .csv file into MS-Access or import the data from Excel?

Directly from .csv

 

[JHB]

Then first import the data from the csv file into a temporary table and then create a query to do what you want to do with the data.