Excel Data Import

[Emine]

Hi Everyone, I have an excel table that looks something like this

Student Address Hotel
John Doe 123 Somewhere St. Regency
Jane Doe 456 No Where St. Regency
John Smith 789 Blvd. Regency

I made a dropdown for the Hotel, but there are multiple same name hotel.
What VB code do I use so that the drop down does not show multiple same name
hotel and only show it once? I would like my drop down to show Regency,
Marriott, etc.
Is this a VB code or do I write a query. Can someone please tell me how do
I fix this problem. I do not know how to write the code or create the query.
Thank you for all your help

 

[NTC]

no vb

while in query design view, with nothing highlighted, select 'View' from
the tool bar and then 'properties' or in 2007 just look to the Property Sheet

and select Unique Values as Yes