I need to be able to alter field names in an existing table populated with data. It appears that ALTER TABLE ALTER COLUMN will permit you do anything except that.

To be clear, I import customer data from Excel and then have to make it conform to my program's table specifications. I have been able to change field widths, change character to numeric, etc, but I need to change client A,B,C field names to Custname, Address, etc without affecting the data.

Any thoughts would be appreciated.

--Herb Mann