How to export results of a report to a file

[gohsk]

Hi All,

I need some information on how to save or export the results of a report to a file.

Thanks and regards

 

[koresnordic]

Sorry, cannot save a report, but can use the transferspreadsheet function to save any underlying query or table.



Graham

 

[gohsk]

Am I able to save specific data from the table to a file if I use the TranferSpreadsheet method ?

 

[koresnordic]

If you just want specific data, then use a query to extract just the fileds/records you need. Then use this query in the transfer spreadsheet function in place of the table. You can do this inside a macro.
goto the macros tab. Select new. The only action is transferspreadsheet. Change the transfer type to export. Make the type a version of excel that you can use.In the table name - enter the query name you have just created. enter a file name - include full path to where you want it stored. Save this macro with a name you feel is relevent and when you run it - it will create the spreadsheet. A word of warning - it will not ask if a file already exists with this name - it will overwrite it.



Graham

 

[kgriffin]

Graham-

I actually WANT the transferspreadsheet command to overwrite the file, but I can't get it to.

I have an Excel file with a graph and report on Sheet1. I would like the user to be able to click a button on an Access 97 Form (which uses the transferspreadsheet command) to export two queries (qryReport and qryGraph) to the existing file. Both queries are based upon a Well #, which the user selects.

I would like the user to be able to select a Well# and click "export" ... and have it overwrite the existing data in the "qryReport" and "qryGraph" sheets of the named file. That way, Sheet1 won't lose the reference to the imported files.

Is it possible to get Access to overwrite the data? Or can you suggest another way of accomplishing the same task?

Thanks

 

[GingerR]

how about making your charts in Access instead of Excel?

 

[Kanga35]

Hi there,
Have you tried to add the send email button on the report tool bar. When your report is in preview then click send email which will open a window to select either word, excel or snapshot etc... select and it will attach the file to the email, then you may save the email or send it. If save it will be in your inbox with the file.

 

[CosmoKramer]

Please see the following thread:

thread703-539535

It is possible to export a report to different file formats....