Hi all. I have a form from which I click a button to import data into a new table. then I want to click another button to cause that data to be appended to an existing table. (no I don't want to go direct to the existing table) the hitch to it all is that the existing table and the new data table don't have the same field names. actually the REAL hitch is that the new data table will have different field names every time I use it..so just designing an append query and mapping the fields won't work. What is the best way to go about this? I have basic VBA skill but can't quite figure out what is needed to accomplish this task.
thanks in advance Betty
