>Since I have to validate the structure anyway, I tested for the name of the field and used alter table if it was different to make sure the field names match the upload structure. Then I could query the table and add the new fields needed at the same time then append from to the fix structure of the upload table for uploading.
Remember that ALTER TABLE ... ADD COLUMN will add the columns to the end. That's why I suggested creating the entire structure.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
