SQL copy data from column

hello there,

how is it possible that i can copy data from an entire column (A) into another column (B), within the same table.

i am doing this because i have difficulties in renaming columns.

thank you very much.

note: MS Access 03 VBA

Astro.

With SQL?

Two calls..

VB Code:

CurrentDb.Execute "ALTER TABLE tablename ADD COLUMN NewField type NULL"
CurrentDb.Execute "UPDATE tablename SET NewField=OldField"

Where type in the first SQL represents the field type that you are creating...

For more info try ALTER TABLE - SQL Command

Although this relates more to SQL Server it is possible to do this as a Hidden SQL option on Access