title: populate access table using dynamic column names
body: <p>this is for an access 2016 db
  I have say 50 tables that have a total of say 100 unique columns
  so I can create a blank table with all 100 columns</p>
  
  <p>so table 1 might have cols 1, 10, 99, table 2 might have cols 2, 15, 27, etc 
  I would prefer to programmically iterate through the 50 tables in the db
  and as I read the records for each table dynamically associate the col name and its data so I can populate a 100 column target record columns with whatever column data there is in current table and write out all the records. naturally there will be many blank fields in the 100 col record.  I know how to iterate through all tables and then get all the column names in each table, and get the table records data but can't figure out how to dynamically create the output records, actually not sure if it possible? 
  If possible can somebody help with enough of a sample to get stated or links of course</p>