Reporting in Excel

M

Martin Wilson

Hello,

I have a simple application in Microsoft Access 2003. I
would like to create a button which displays a report in
MS Excel. Does anyone have any code for that?

Thanks,

Martin Wilson
 
G

Guest

hi,
to transfer data from access to excel, use the
tranferspreadsheet function. you can do this with a macro
or with code. i learned what i needed to know about this
from access help.
What do you mean by "report in ms excel"?
access cannot tranfer a "report" just data. if you have
in mind to arrange the data in excel with fancy formating
then you may have to do some coding in excel also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Possible to Combine reports to's to a single box? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Macro to copy table of contents to a new doc 0
No option to create a list in SharePoint Site 0
Autonumber field in Excel that behaves the same as Access 0
Integrating information from Word to Excel (not mail merge) 1

Top