Reports to be exported automatically to Excel

[Jo Gjessing]

Hi all,

In a Access database of mine I want to create several reports which I do not
want to be sent to the default printer but be exported automatically to a
Excel spreadsheet. As I'm not at all an experienced user of Access I do hope
anyone can tell me how to do this. I've searched in books, in this forum and
elsewhere without success. So, please give me some words. Thank you very much
in advance.

Jo

 

[Chuck]

Hi all,

In a Access database of mine I want to create several reports which I do not
want to be sent to the default printer but be exported automatically to a
Excel spreadsheet. As I'm not at all an experienced user of Access I do hope
anyone can tell me how to do this. I've searched in books, in this forum and
elsewhere without success. So, please give me some words. Thank you very much
in advance.

Jo

Do it with a Macro:

OutputTo
Object Type Query
Object Name name you want for Excel file
Output Format Microsoft Excel (*.xls)
Output File =full path to desired location of the Excel file including name
you want for Excel file
Example ="E:\Access\Excel_Data\Contacts " & (Format(Date(), " yymmdd")) &
".xls"
Auto Start No

Result is file named Contacts 080117.xls saved in folder
E:\Access\Excel_Data\

Obviously you don't need a date. However the macro doesn't have provisions for
different file names so tacking a date (or date and time) on the end will make
a different file each time the macro is run. And the name tells you when the
file was made. No big deal if the Excel file is renamed or deleted before the
macro is run again.

Chuck
--