I have an Access database with a field in called 'Category'. This field contains several records with the same value, e.g

CATEGORY
News
News
News
Games
News
Games
Games
Games

What I want to do is get a list of all the different category names using ASP. How do you do it?