Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You could use a mapping table you automatically create with FieldName() and then use rename fields using [Mapping Table].
Rgds,
Joachim