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