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.
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.
