WOW! Thx to you all for pitching in.
I have to admit that I did not mention lots of info because I was looking at ideas and some brainstorming. What i want to do is as follow:
0 - Combo list for selection of which table to update (around 10 table possibilities)
But, lets pick one...
PART 1
1 - Naviguate to an excel file and load it into a temp table called Tbl_sow_import (Preparation for update or append)
2 - Output a list of columns names for Tbl_sow_import into a form txt field (For user conf.)
3 - Output a list of columns names for Tbl_sow into a form txt field (For user conf.)
4 - Compare both list to each other to validate the qty and column name, and populate a txt.box with MATCH or NO MATCH
5 - Select if you only want to update the table, or update an append.
6 - If there is a match unhide the import button since both are the same
7 - Delete all temp tables once done
OR, on another form
PART 2
1 - Naviguate to an excel file and load it into a temp table called Tbl_sow_import (Preparation for update or append)
2 - Output a list of columns names for Tbl_sow into a form txt field (For user conf.)
3 - Side-by-side, create one combo box per header column found in the excel Tbl_sow column field.
4 - Select if you only want to update the table, or update an append.
5 - Match individually each of the column field from Tbl_sow to the choices taken fromtheExcel headers.
6 - Name each boxes with strCBox1, strCBox2, strCBox3 ... as they are created on the fly. Positionned properly
7 - Use those values to build the SQL query and update the appropriate table, in this case Tbl_sow
8 - Once all fields are matched, unhide the import button.
9 - Delete all temp tables once done
Most of it works so far for part 1 and 2, I am at creating the SQL command. But do not understand why MSAccess would keep any data once done and everything is trashed.
a. Creating a form on the fly without saving is somewhat easy and could work in conjunction with ComboBox temporary creation since creating the combobox is also easy.
Hide and unhide boxes is not interesting to me as the amount of headings will change from different type of updates. I want on the fly by using the count function for the amount of boxes needed.
Thank you so much guys for the input, so far the import in part 1 works as intended, but still need work on part 2.
I placed a representation of the results as attachments