Rename fiels

[jbo]

Hi,

I have a table with about 70 columns and each column name is right now @1, @2..etc but shoud be renamed to years starting with 1940 up to 2008.

Is there any way, perhaps with a for-statement, that I can rename all automatically rather than having to do it manually so to speak?

[biester]

You could use a mapping table you automatically create with FieldName() and then use rename fields using [Mapping Table].

Rgds,
Joachim