Exporting to an Excel Template

[barsa]

I have a report that gets created in Access, and I would like to be able to create a template in Excel to where the Access report could be exported, and once in Excel, the report could be edited.&nbsp;&nbsp;As of now, the Access report cannot be edited.&nbsp;&nbsp;<br><br>Can this be done?<br>If so, how can the fields in the Access report be directed to the Excel template?&nbsp;&nbsp;Do the fields have to be mapped?<br><br>

 

[kathryn]

Do you really need to have the _report_ exported, or just the data from the report?&nbsp;&nbsp;If it is just the data, I think the solution will be easier.<br><br> <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>

 

[barsa]

I only need the <u>data</u> from the Access report. Once in Excel, the user will be able to edit the data (calculations).&nbsp;&nbsp;I am assuming that I would be able to have the data imported into Excel in some type of report format.&nbsp;&nbsp;Am I assuming correctly?

 

[kathryn]

Actually, Access has a great method, OutputTo, which sounds like what you are looking for.&nbsp;&nbsp;Check out the help file and see if that is what you need.&nbsp;&nbsp;The method can output directly to *.xls format.<br><br> <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>

 

[jimmythegeek]

So can the TranferSpreadsheet Action/Method.<br><br>However, both the output to, and the TranferSpreadsheet method, can only save the data as a .xls file. They <b>CAN'T</b> plug data into particular sheets and cells on a spreadsheet or template. You can only do this with code using Access and Excel VBA objects and methods. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[jurgen]

Is it possible to first use the TransferSpreadsheet, and then send the generated file as an attachement to an email ?

I'm truying to dump info from a database to excel and send it to the persons who need the file.

This dump is about 20 times a day ... any help

JJ