Originally Posted by
Perceptus
Yes, I have used a similar process to handle MLS data imports to access. It involved using a Dictionary Object and comparing the fields in the excel file against the fields returned for the table. if the dictionary found a new field, then it would fire off an alter table statement. The issue you may run into is where fields are dropped and then added multiple times. You can only add soo many fields afaik.
Surely there are better ways to do it now, but should still be possible.