Import excel into access with a condition

[xion.hack]

Hello. I have an excel table with two fields "Name" and "Amount" and I have an access that has "Name", "Number", and "Gender".

What I want is to make another field in access named "Amount" And to import the table so if the name in excel and the name in access is the same, to put the value in the "Amount" column into the "Amount" field in the Access database. How can I do that? Thanks!

 

[John Big Booty]

You will need to do this in a couple of steps.

1) Create your additional field, in your Access Table.
2) Import your excel data into a temporary table
3) Used the "Find Unmatched Query Wizard" to create a query to, as it says, find unmatched data.
4) Convert that query into an append query to append the data to your existing table.