> A lot will depend on how often you plan to do this.

* Hopefully not very often *

> Create a view to the Access data. Then SELECT from the view, aliasing the field names and put the results into a table. (SELECT Field1 AS MyNewName...)

I will try this. Thanks.

Thanks to everyone else for the replies.

I got very *mad* and just changed all of the variables in MS Access. Solved. But this is not the *lazy-non-redundant* method.

I am going to set it up so I do not have to do it. So I can be *lazy* again.

Ray.