If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Export access reports data into excel sheets
Hi,
I have some Access reports and I want to export those reports (data ) into Excel. Is this possible? I have researched on this, and I figured how to export the data in the table to the excel but not the data in the report. Could you guys, please help me on this? |
#2
|
|||
|
|||
Export access reports data into excel sheets
Hi,
I have a small correction. If we right click on the report and select "export", we can export that the report data to excel. But what I mean is, if the users don't have the permission to directly view the reports (they can only launch the report from other forms), how can they export that report data to excel? Thanks Praveen Manne "Praveen" wrote in message ... Hi, I have some Access reports and I want to export those reports (data ) into Excel. Is this possible? I have researched on this, and I figured how to export the data in the table to the excel but not the data in the report. Could you guys, please help me on this? |
#3
|
|||
|
|||
Export access reports data into excel sheets
The RecordSources of the Reports can be a Table, a Query or an SQL String.
Use the RecordSources (rather than the Reports) as the Source for your exports to Excel. -- HTH Van T. Dinh MVP (Access) "Praveen" wrote in message ... Hi, I have some Access reports and I want to export those reports (data ) into Excel. Is this possible? I have researched on this, and I figured how to export the data in the table to the excel but not the data in the report. Could you guys, please help me on this? |
#4
|
|||
|
|||
Export access reports data into excel sheets
I think you can just click on the report (not open it, just select it) and
use Tools, Office Links, Excel. But I think you would get a cleaner result if you export the underlying query to Excel and then format your report in Excel. If you rather export the report, you may lose the formatting. Any calculations are done just as easy in Excel as they are done in Access, and it is quicker. As a rule, I format any reports that are used again and again in Access, but I export data that is for one time use only into Excel and format it quickly in Excel. Brigitte P. "Praveen" wrote in message ... Hi, I have some Access reports and I want to export those reports (data ) into Excel. Is this possible? I have researched on this, and I figured how to export the data in the table to the excel but not the data in the report. Could you guys, please help me on this? |
#5
|
|||
|
|||
Export access reports data into excel sheets
You can do a macro which will export your data to Excel and then create a
button which will run the macro on the form the user has rights to. The record source for your macro can me either the query, table, or report (I think). The only problem I have encountered with this approach is the location of the Excel spreadsheet. If you work in a network environment, you may wish to direct the Excel spreadsheet to the same location the database is stored. If this is confidential data, you may want to send it directly to the users local hard drive where the user then can delete or password protect the spreadsheet. But try the macro approach; the Access help will lead you through the process. Brigitte P. "Praveen" wrote in message ... Hi, I have a small correction. If we right click on the report and select "export", we can export that the report data to excel. But what I mean is, if the users don't have the permission to directly view the reports (they can only launch the report from other forms), how can they export that report data to excel? Thanks Praveen Manne "Praveen" wrote in message ... Hi, I have some Access reports and I want to export those reports (data ) into Excel. Is this possible? I have researched on this, and I figured how to export the data in the table to the excel but not the data in the report. Could you guys, please help me on this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export access reports data into excel sheets | Praveen | Using Forms | 4 | July 20th, 2004 02:20 AM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Getting data into Excel cells for OLE objects retuened from Access | Raj | Charts and Charting | 1 | January 16th, 2004 01:37 PM |
Excel - Import External Data from Access | VLeonard | Setting up and Configuration | 1 | November 7th, 2003 06:59 PM |