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?