> 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.
--
Raymond A. Biondi
RSL