Hi

I am trying to write some code in Excel VBA but I need to query an Access Database for the data it contains. I have found some SQL stuff online but I have had no luck with sites explaining how to link to and query an access database from excel. I have found sites and forums that give solution but nothing really explains the syntax well. I need to understand the syntax and how to structure this in excel VBA. any help or links regarding this would be great (tutorials would be a big help). I don't just want to implement some solution without understanding it.

Thank you