Crosstab Query to Excel...

[dodgyone]

I have created a crosstab query and from this I have created a form.

How can I send the data displayed to Excel so that only certain fields (which I specify) are transferred from the form (I have tried the regular analyze with Excel feature but this isn't really an ideal solution). I have already created an Excel file which has a chart in it to display the data received. Can I transfer the Access data into the already created Excel file and then select where the information is placed on the worksheet (so that Excel uses the information for the chart)?

Any ideas would be welcomed... thank you

Marcus

 

[MichaelRed]

For limiting the field transfered, you will need an additional query to select the fields to be transfered (you can also limit the "rows" of data with standard Where clauses/criteria).

For the actual transfer, look up "TransferSpreadsheet" in Help. Pay particular attention to the named range argument.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over