How to Get records from a query in access and put them in Excel
 

Open your Database.
Go to Queries.
Click on the query you want sent to Excel.
In the Main Menu, go to File--Export
Select where you want it saved and MOST IMPORTANTLY select the version
of Excel you want to use from the drop down menu labeled "Save as
type:" at the very bottom of the window.
Click "Save".

Ta-Daaa! - Pikus:cool:


---
Message posted from http://www.ExcelForum.com/