Thanks for the input everyone. I solved the problem by adjusting the Excel template. I added an automunber column as the last column in the template and hid it. That ensured every record had the same number of elements now matter what the user entered.
This now allows users to users to download an Excel template, populate that template with data, then upload the complete spreadsheet to mass populate a data base. The program parses the spreadsheet, validates the data, updates a data base and all relational records, etc. This allows users to add/update records in mass. It is working now. It was a pain to work with but it's a nice feature for the users. Thanks for the help. Robert Harrison ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
