ADO/DAO query to rename table fields?

[sbcglobal]

I have a table, 'Customer', which I want to use VBA/ADO to auto rename all
the fields. for example, to rename fields 1 to 'customer name', field to
'customer address' ,etc.

in Access, there's query 'Alter table, Alber column' but it only do for
changing column property, say set column as text/number, etc. I don't know
there's way to use SQL to rename a field in table.

I use Access2003 ANSI92. Thanks for any hints!

Warren

**************************************************
The Spoon Does Not Exist.

 

[Michel Walsh]

Hi,

You can use a query (but you loose index):


SELECT column1 As newName1, column2 As newName2, ...
FROM mytable


Hoping it may help,
Vanderghast, Access MVP