ADD COLUMNS to Existing Table

[sjck]

I am a novice when it comes to SQL and Access. I am trying to add several Columns to a Table that Exists using ALTER Table. Can I do this in one statement or do I need to use a different ALTER TABLE statement for each column. If this is able to be performed in one statement what is the syntax (I have looked through the books, the forum and can only find examples that add only one column. I cannot find an example to add more than one column)

Right now I have

ALTER TABLE [Repice] ADD COLUMN myID COUNTER(1,1); -- thanks to PHV

I have tried

ALTER TABLE [Repice] ADD COLUMN (myID COUNTER(1,1), column2, column3); but receive errors.


Thank you for you help

 

[willybgw]

Why don't you just go into table design and add the columns there?

willybgw

 

[sjck]

I am attempting to automate a very manual process. We receive excel spreadsheets where we have to manuiplate the data based on several criteria. And I wanted to create a query so I can have it run in the macro I have also created.