Thanks, that worked for the insert, but not for the update file. I think at one point early on I had tried that for the update and when it didn't work I changed it back to default and then didn't do anything with it when I made the insert version just to test.
I will say that the update file does insert null values into the columns that were previously blank, so it is doing something, it just won't overwrite the data that is already in the database.