The index is set up as a primary key. I do not have any duplicate values, and all data is populated. How does the append from work, does is add blanks records according to how many you will be appending?

I replaced the append from statesment with code that appends a blank, then stores all data to variables, the replaces the blank records with the variables. This works.