I would like to be able to link an Excel workbook to a MS Access query. I attempted to use Mircosoft Query which is already built into Excel (DATA | Get External Data | New Database Query), but I can’t seem to duplicate the same query as the query I created in MS Access. My MS Access query has several expressions built from multiple tables. Can anyone help with setting up this link to Excel?
