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.

[June7]

Don't understand what you mean by 'master' and 'slave' tables? Don't understand the interaction between csv, Excel, Access. Are you importing into Access from Excel or csv?

How should color names be translated into people names?

[alexbeatle]

Don't understand what you mean by 'master' and 'slave' tables? Don't understand the interaction between csv, Excel, Access. Are you importing into Access from Excel or csv?

How should color names be translated into people names?

Thank for reply.
Let be try to better explain.

Right now, I use Excel only. I have a Master sheet and everyday I generate a .csv sheet from emails (lets call it Slave sheet). Both have record numbers. This .csv sheet updates some columns in Master sheet, if the record number in .csv matches the one in the Master. Otherwise it adds new record.

The emails come from Outlook. It has an option of colour-coding, where each colour is assigned to the person who looked and responded to that email. The generated .csv contains the colour names. I think I can just create a lookup table in Access for that part.

I want to convert this into Access database.
In the end, Access database should contain all the records from the .csv and I should then be able to generate reports on:
- the records of emails looked at + name of the person who looked at it
- the records of emails yet to be processed.

[June7]

Can certainly do the same UPDATE/APPEND in access tables.

I still don't get the color assignment. Why not just use people names or ID?

What exactly do you need to understand?

[alexbeatle]

Can certainly do the same UPDATE/APPEND in access tables.

I still don't get the color assignment. Why not just use people names or ID?

What exactly do you need to understand?

Right now, I'm looking at the UNION query, how would UPDATE/APPEND be different from it?

[June7]

A UNION query doesn't edit records or add records. Why would you consider UNION?

[alexbeatle]

Can certainly do the same UPDATE/APPEND in access tables.

I still don't get the color assignment. Why not just use people names or ID?

What exactly do you need to understand?

I'm new to Access and came across UNION.
So you're saying, the UPDATE/APPEND queries are more relevant?

[June7]

If you want to add/update data from a csv file into Access table, yes.