VBA to query data from MS Access DB using ADO

[Lekster07]

Hi, I'm not sure if this is the right forum to ask this question, but I'm looking for a code to get data from an MS Access database with given criterias. Say, I have an Access database, table name is Names with 3 columns, ID (autoincrement), Name (text), and Location (text). With a VBA code, I want to copy all records for a given Location and paste it to a sheet in Excel. I could maybe assign this code to a button in Excel.

Thanks in advance!
PS. It would be great if I could use ADO on this with a very very simple code.