A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Export access reports data into excel sheets



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2004, 12:50 AM
Praveen
external usenet poster
 
Posts: n/a
Default 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  
Old July 20th, 2004, 12:58 AM
Praveen
external usenet poster
 
Posts: n/a
Default 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  
Old July 20th, 2004, 01:07 AM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default 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  
Old July 20th, 2004, 01:12 AM
Brigitte P
external usenet poster
 
Posts: n/a
Default 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  
Old July 20th, 2004, 02:20 AM
Brigitte P
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 05:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.