I did find 2 empty dates and also a few bad dates (year < 1753.) Once all of those were cleaned up, I was able to append the data successfully. The message about character value was misleading. Thanks for your help.