How do I add a column to a table with a query?

[Guest]

I have a master table that I import my data into. Then I have to Delete
certain data rows with a Delete Query. Then, I have to bring back the rows I
deleted (From another table with more accurate data) along with a few columns
that the original table does not currently have. How do I easily add those
new columns to my original table?

Also,
I need to keep the original table in the unmodifed format so that when I
import the new data, it will match... correct? So, I'm making a copy of the
table after I update with new data so I can make my deletions and additions.
Would you suggest doing something different?

 

[Brendan Reynolds]

To add a column to a table using a query use the ALTER TABLE and ADD COLUMN
keywords, for example ...

Public Sub AddAColumn()

CurrentProject.Connection.Execute _
"ALTER TABLE tblTest ADD COLUMN MyNewTextField nvarchar(50)"

End Sub

Here's a link to the online help topic for the ALTER TABLE statement ...

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP010322071033

 

[Guest]

Thank you so much!!! It worked great! --- I have so much to learn.... not
enough time! - Happyd