exporting data

[emcf]

I have been searching the archives of this site for two days trying to find the answer but, alas, i still cannot get access to do what i want it to do -

I am trying to export the results of a query into an excel file - this excel file will produce a graph....exporting to excel is not the problam, my problem is that i need to send the data to a specified range of cells in order for the graph to work.....can anyone help me?

 

[pdx_man]

Using the simple OutputTo will not allow you to specify the range to export to. But I do have two thoughts:

1) Adjust your graph's lookup range to the default placement of the export.

2) Retrieve the query results from Excel using MS Query.
From Excel: Data ... Get External Data ... Create New Query ... OK
Then follow the wizard selecting the driver, database source and query. This will allow you to put the data where you want it.

HTH

 

[emcf]

cheers pdx_man, that does the job perfectly. I was wanting to automate everything to make it easy for users.....i'm sure they will be able to click the mouse button a couple more times to do what they need to!
your help is very much apopreciated.

 

[spilwayboy]

This thread also did exactly what I was looking for except if there is not value in the columnExcel leaves the column out. I tried the nz() expression in the query but then Excel does not recognize the nz function. Any suggestions, other than that it leaves out 2 columns it works great. The access query that excel gets the data fromshows the columns till it goes to Excel.

Thanks for the help,
Spil

 

[pdx_man]

Post the SQL used in Access using the NZ() function for me, please.