Hi all!

Simplified Example:

My Access database has 6 columns, the fourth of which is called "Category".
This category column consists of, say, 30,000 entries, each entry being
either "Apples", "Pears" or "Plums".

Please could someone help me with an example of some code to change all
references in the "Categories" column of my database from "Apples" to
"Oranges".

Thank you in advance

John

I am using Excel version 2002