We are currently running MSAccess VBA software. It has several custom queries that access ODBC sources. We would like to be able to export the results of these queries into an excel document. We have a screenshot of the proposed and tentative form design.
## Deliverables
The form should present the user with a listbox containing all of the queries in the CURRENT database that start with "_". These queries act on linked tables in the current database; this project is not responsible for the actual linking, so as far as the development is concerned, these are local tables.
The format for the Excel files should be for Office 2003, not 2007.
Our goals are to export the data from the queries into a more usable excel format. End users are already able to run the queries, so we'd like this form to also be user-friendly.