Querying data from Access question

[Mr930]

I wish to execute a query saved in Access and have it dump to the same range on my spreadsheet each time I run it. The first time I run it no problem, it creates a table. But the next time it will not let me overwrite the existing table. Each time it runs, the number of records returned might be different. How would I set this up to keep writing to the same range?

thanks
Fred Emmerich

 

[Derek Brown]

You did not say which version of Office is being used so I can only give a general description.
I would link to the Query from Excel - something like Data | Get External Data | From Access.
You would need to check the properties where you can say whether or not to refresh on opening the workbook, refresh in the background and (I find this important) the 'mode' of the data link - this tends to default to "mode=Share Deny Write" and I change it to "mode=Read".
In Office 2007/2010 the data will be formatted as a table in Excel - I believe it would be a 'List' in Excel 2003.