Changing the field names of linked table

[Guest]

I have an ODBC link to some live data.

Unfortunately the field names for this data are just codes and aren't very
helpful.

Though I have made a table in access which links the codes to the actual
description.

I need a way to create a new table which has all the data from the ODBC link
but for the field names it uses the field description rather than the field
code.

Can someone help?

 

[Rick Brandt]

I have an ODBC link to some live data.

Unfortunately the field names for this data are just codes and aren't
very helpful.

Though I have made a table in access which links the codes to the
actual description.

I need a way to create a new table which has all the data from the
ODBC link but for the field names it uses the field description
rather than the field code.

Can someone help?

Create a SELECT query based on the table and change the names of all of the
fields in the query. Then use the query everywhere you would otherwise have
used the table.