Hello, I'm beginning to learn Access and I can't seem to find the answer so I think I'm approaching this in a wrong way.
I have an Excel linked table(excel table) with 4 columns.
Name, Address, Amount, ID
From this table I run an apend query to an access table (Table1) with the same columns...