Save report contents to a table

  • Thread starter Thread starter Koulla
  • Start date Start date
K

Koulla

Hi,
I have a report that contains data on it. I want that
data to save them on a table. How can I do that?
I have access 2002.

Thanks a lot.
 
Koulla said:
I have a report that contains data on it. I want that
data to save them on a table. How can I do that?
I have access 2002.
Click to expand...


Reports don't have data, they just display the dataset
specified in their record source. Whatever you're using for
the report record source table/query can be used in in
another query that either adds the data to an existing table
(Append query) or creates a new table (Make Table query).

You should be aware that this is a pretty unusual thing to
do, which implies that you should rethink whatever you're
trying to accomplish to see if there's another way to meet
the needs instead of this save operation.
 
I have a report that contains data on it. I want that
You should be aware that this is a pretty unusual thing to
do, which implies that you should rethink whatever you're
trying to accomplish to see if there's another way to meet
the needs instead of this save operation.
Click to expand...

This isn't that unusual. I need to do it to, and I have seen similar
posts going back a few years trying to do similar.

I need to store reports as a finished item that can be kept
historically.

I thought about saving as RTF with DoCmd.OutputTo and then saving the
RTF file text in a Memo table field. But then how do you then open a
report using that RTF text? Seems strange to be able to only convert
in one direction.

Another option was to embed the RTF file in to an OLE Object table
field, but apart from not finding how to do this in code, I would
guess the database could get very big very quickly.

Any help would be appreciated.

James
 
Back
Top