Adding a field to a table through a query

[anderson7]

While downloading information from Banner into an Access table, a couple of fields that aren't needed at that point, are knocked out of the table and need to be put back in manually. Is there anyway this can be done with a query?

Also, Banner changes a couple of data types as well later on in the process...is there anyway to change these back using a query?

Thanks for any help!

 

[pbaldy]

Sure; you want a DDL query. Look in Help on that or "ALTER TABLE", which is how the SQL would start.

 

[anderson7]

thank you!