Macro to run Ms Query and import the data into excel

Hello aryans1in,

Welcome to the Forum!

Since Access queries can be translated directly into SQL, transferring data back and forth between Access and Excel is not to difficult. Excel requires using ADO to setup the SQL server connection and retrieve records, something you don't have to do with Access. Once the data is in a workbook, the remaining programming can be done in Excel VBA, and handled locally.

Sincerely,
Leith Ross

A.S.
Yes you can have a button run each Access query one after another then call you Excel wookbook.
You could have an auto start macro in Excel that will refresh each sheet's query data. It can then close Excel and save it with a date specific name.
When you say you want the file to have a date specific name, do mean in Access or Excel?

I can come up with samples later today if you want.

ReBoot

I was going to attach a sample database and Excel file, but they are over 100kb even zipped. Seems to be the limit here.
If you email me at DontBuggerMe@Yahoo.com I will send them to you.
ReBoot