Hi everyone,
Thank you so much for all of your inputs!
Unfortunately, the root cause of the issue was my assumption that appending data types within the design view of the table would clear the "type conversion failure" errors I recieved. I decided to re-import the entire table while...