Link to home
Start Free TrialLog in
Avatar of exp vg
exp vg

asked on

Access - rename column

Please offer if there is a straightforward way to rename the columns in an Access table.

The research I have done is complex, using Alter Table with Add and Drop of columns.

It is preferred if I can have a query statement that is a direct rename, i.e. ColumnA = ColumnA1, ColumnB = ColumnB1, etc.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of exp vg
exp vg

ASKER

Thank you....much appreciated.