I am trying to make a table that validates data as it is imported into access from excel.
To do this I have
1. Created a link table to bring the data into access from excel
2. Using a macro I am copying and pasting the data from the linked table into a full access table.
However the full...