The best way to start is to record a macro while setting up the query manually.

From Worksheet menu
1) Tools - Macro - Record new macro
2) Data - Import External Data - New Database Query
3) Tools - Macro - Stop Recording.

"Denise" wrote:

Can I execute an Access query from an Excel Macro and bring back the data
into the spreadsheet?