I am trying to use Access as a better way to handle test scores from third party software. I am able to export from these software's into Excel and then after cleaning up the data I am trying to import it into Access. I have gone around all the most obvious troubleshooting steps (looking into the data that has the error and making sure its all the same type as Access has assigned it, ect.) I have also noticed while the errors look random the columns are being attributed to random students instead of random column/row errors. I have also looked into this side of the problem and one of the "problem" students would have an error for a score that's, for example, 42. I am really at a loss on how to fix this problem as well as being newer to Access. Any help will be appreciated!