Export, and then re-import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to export an Access query to Excel to make a complicated graph
that access is not able to create, then Import that graph to be included in
an Access Report. Is this possible to do? The version I'm using at work is
Access 2000 (unfortunately).
Thanks for any help.
 
It is possible to include an Excel object in a report.
Create an ole control, and insert a spreadsheet into
it.

I think that because you are using an Excel object,
it will probably re-calculate the graph based on
current data, which is what you want.

I normally use an append or create table query to
export data to Excel. You might be able to do something
using TransferSpreadSheet.

(david)
 
Back
Top