access and excel

A

antonov

hello, my boss wants me to produce an excel sheet at the end of the month.
this sheets contains data which I have in access. I would like to know if it
is possible (and how) to export only the data needed (the data has to go on
rows and not every day has data.....)
thanks for any help
 
G

G. Vaught

Create a query that contains the data you need. On the Access Menu select
File | Export. From the file type chose Excel.
 
M

Mark

Well, there are a few ways to do this.
1) Export out the query/table. Right-click on the file, select export, save
as Excel
2) Run the query, click Tools | Office Links | Analyze with Excel
3) Create a query and copy and paste into Excel
4) Excel Automation through Access. This page has sample code
http://www.mvps.org/access/modules/mdl0035.htm
 
Top