Running an Access Query From Excel
 

Does anyone have any sample code I can use to run an Access query from Excel
using VBA.

I have a linked table in Access to an named range in my Excel workbook. I
also have an Access query which appends the Excel data to an Access table.
How can I run this query from Excel VBA?

Paul Smith