Get the data from a report in Access 2000?

[kutlesh]

I have large reports and a colleague told me, to export each of them as rtf file and then copy its contents to xls.
However, it has lot of editing which takes time.

I was wondering if there is some way to export just the data to xls or maybe in an Access 2000 table?

[westconn1]

without knowing what you are doing, i assume that the reports are based on some query of a table(s), so it should be possible to use the same query to export the data by various methods

one of which is to automate excel then use the copyfromrecordset method of an excel range
another option would be the creation of an excel table from a query as in your other thread

if my assumption is incorrect, how are the reports created?

[kutlesh]

I am not Access 2000 expert, but from what I see, the reports are created with many OpenQuery macros and many of the fields in the reports generate its values by using inline scripts(Is it expression editor?).

Suffice to say, make table query append query, append query,..., append query, open report
or something like that.

[westconn1]

i would believe that you should be able to return the creation query from the report, only don't ask me how............

[kutlesh]

I see that is already ugly, business logic inside the report and lots and lots of macros/queries.

No I am not asking you to do my job

[westconn1]

No I am not asking you to do my job

not because of that, cause i do not know at all, but i figure it should be a property of the report or something like that

try a google like access report source query