Adding Columns to an Existing Table

[J Bhujanga]

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!

[ranman256]

if you have 150 fields, then your table is designed wrong.
these fields should be related in a sub table ,not constantly adding on to the master record.

[J Bhujanga]

Be that as it may, it's not something we have any control over. The data is sent to us from a State database this way. I can't do what I need to do by creating queries. Our job is to recondition this data into another flat table structure that is compatible with another program that will be using it.

[pbaldy]

How about:

http://allenbrowne.com/func-DDL.html

[J Bhujanga]

That should do the trick. Thank you.

[pbaldy]

No problem, and welcome to the site!