hi,
it is to my understanding that you can do it either way.
right click the MSQ, then click data range properties.
at the bottom you can opt to insert rows for new data or overwrite existing
data. not sure which is best. i always overwrite.
links....
http://office.microsoft.com/en-us/ex...747511033.aspx
http://office.microsoft.com/en-us/ex...CH100648471033

regards
FSt1
"patti" wrote:

a simple stupid question....

does msquery add the data to what is already there or does it replce the
data? (query is linked to access db)

any links to explanations and examples of msquery appreciated.

thAnk you!

patti