<div>
50 does sound like a lot, but you could start a new &quot;MDBMaster&quot; and then link all tables from all databases to this one MDBMaset.<br />
<br />
Then you could create a form and do your two drop down boxes.<br />
<br />
But I think your question is more relating to the connecting of all databases right?
</div>


50 does sound like a lot, but you could start a new "MDBMaster" and then link all tables from all databases to this one MDBMaset.

Then you could create a form and do your two drop down boxes.

But I think your question is more relating to the connecting of all databases right?

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I look after around 50 databases on a network and I am wondering if it is possible to have one central database where I can go into and select any query from any of the databases (held in a table within that database, along with full paths) and export that query to an Excel document and save it for example in the C:/ drive with the file name of the query.<br />
<br />
So ideally there would be a form with two drop down boxes, one with the database name and the other with the queries from that selected database and a export button.<br />
<br />
Is this something which can be done?<br />
<br />
Thanks<br />

</div>
</div>


I look after around 50 databases on a network and I am wondering if it is possible to have one central database where I can go into and select any query from any of the databases (held in a table within that database, along with full paths) and export that query to an Excel document and save it for example in the C:/ drive with the file name of the query.

So ideally there would be a form with two drop down boxes, one with the database name and the other with the queries from that selected database and a export button.

Is this something which can be done?

Thanks


One central access database to retrieve queries from other database and export to excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.