21st January 2006, 07:22 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by Chrome Prince
Hi La Mer,
Have you tried using related access tables?
I have all the values and corresponding decimal equivalents in one table, then import my excel files into a related table.
The query then substitutes the old value to the decimal odds.
|
Thanks for the advice Chrome - one problem, I don't have Access but will keep the information you stated above in the back of my mind for future reference. |