I am downloading data from a website to append to a table. My procedure is:
1) Download the data to an excel spreadsheet.
2) Import the spreadsheet to a holding table.
I'm having now problem getting the data from the spreadsheet to a holding
table. Now the problem I'm having is with transferring the data from the
holding table to the main table. The problem is that some of the fields that
are in the main table may not be present in the holding table. So if I have
an action query that names each field and some are missing, there is a
problem.
The field names in the holding table are the same as the field names in the
main table. Example:
Main Table Fields
Product
Sub_Product
Style
Shape
Cut
Manufacturer
Model
Holding Table Fields (for a particular download, the quantity of fields might
change with each download)
Product
Sub_Product
Style
Manufacturer
Model
How do I transfer the rows in the Holding Table to the Main Table when I can
never be sure exactly which fields will be present in the Holding Table.
Assume that the main table key fields will always be present in the holding
table and that the fields present in the holding table is always a subset of
the main table fields (there will never be any field names in the holding
table that are not in the main table).
Thank you.
--
Message posted via
http://www.accessmonster.com
Similar Threads
