Add Columns Via Query

[jbfrank]

I have not posted yet to the Access Message Board. I'm also relatively new to Access, so I apologize if I don't word this correctly. I will do my best to explain what I'm looking for.

I need to add columns to an existing table via a Query.

For example, I have a table in Access that's created from a couple of different sources. First I import data from Excel and then use Access to format it and create combinations. The table is a zip code table that shows the distance in miles from one zip code to another.

Once that table is created, I need to add columns (with no data in them). Once those columns are created, I can establish relationships between this new table and other existing tables.

What I'm ultimately trying to do is automate the creation of a very large table. Adding columns via a query is my only hurdle at this point.

Any advice would be appreciated. Thank you.

 

[danial]

Why you use make table query to add new column.

SELECT *, "" AS NewCol
FROM table1;