ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   SPSS QUeries in Excel and refresh data (https://www.excelbanter.com/excel-discussion-misc-queries/182445-spss-queries-excel-refresh-data.html)

mike b

SPSS QUeries in Excel and refresh data
 
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!)


All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com