I'm trying to figure out how to add columns from one table to another existing table using a query or vba code if necessary.
The columns to be added have no data in them - I just want to add them by name and properties. I will need to do this process many times, hence I can't just go into the table design mode and add them.
The tables that I will be adding them to will already have over 150 fields and I need to add an additional 50 or so. We will receive new sets of data (i.e. the 150-field tables) periodically and the first thing I will need to do is add these additional fields.
What is the best way to go about this?
Thanks!