Hi,
I've reched this site "http://www.databasejournal.com/features/msaccess/article.php/3563671/Export-Data-To-Excel.htm" in helping me to export access data to excel and at the same time you can point where on the excel cells will be exported and also what sheet.
I was wondering if it is possible to export 1 query to excel file in two separate sheet depending on what data on the query. Let say, on the query there's 2 division, one division should go to the first sheet and the next division goes to the next sheet when you run the exportation. Is this possible?
Thanks in advance.
Vaikz