SPSS QUeries in Excel and refresh data

M

mike b

we have an excel query that we are linking to a Showcase SPSS database, and
we have a prompt to enter a certain type of data, and we first run it and we
get 80 rows, then we re-run and the results are only 20 rows, but it doesnt
clear out the other 60 rows from the first refresh. Is there a setting in
excel to clear out the data (I know i have run across this before but it just
seems to escape my mind right now!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top