Report output in Excel

M

MSA

Was wondering if its possible to have the report output in Excel and how can
it be done?

Thanks
MSA
 
C

Chuck

Was wondering if its possible to have the report output in Excel and how can
it be done?

Thanks
MSA
Click to expand...
Is your report based on a Query? If yes,
1. make a macro:
output to:
Object Type = query. Object Name = name of your query.
Output Format = Microsoft Excel (*.xls).
Output Fi;e = ="{full path}\{name you want for the output file} " &
(Format(Date(),"yymmdd")) & ".xls"
The format date part is not required, but can be handy.

or

2. File/*Save As/Export*/To an external file or database/
Enter the name you want for the file, chose where you want the file to be
saved. and chose *save as type* Microsoft Excel {version}

Chuck
--
 
J

jahoobob

MSA said:
Was wondering if its possible to have the report output in Excel and how
can
it be done?

Thanks
MSA
Click to expand...

A report in Access is a "picture."
If you want to put the data into excel, copy the data from a query or
use ADO in an Excel macro to transfer.

Info can be found here
http://tinyurl.com/b4mo7
 
Top