Thanks. Converting to CSV didn't solve the problem but made me realized what was the problem. The first records displayed leading zeros not because the data had leading zeros (they didn't), but because of the format (ZIP code).

>You can export to CSV first to preserve leading zeros and then append from it.