2 Replies Latest reply: Sep 14, 2012 10:45 AM by melaniehuggins RSS

    append/accumulate

      Hi

       

      I'm loading in very simple data from an excel spreadsheet. There are a few more cols and thousand odd rows. Similar to below

       

      A/CSALESDATE
      70712491137055056707/01/2012
      70712491118462282308/01/2012
      7071249111846228909/01/2012
      7071249111846228601/01/2012
      7071249111846228304/01/2012
      70712491118462284505/01/2012
      70712491118462281206/01/2012
      70712491118462283

      07/01/2012

       

      then I have another spreadsheet that tells me more about the a/c which is all linked via the a/c col

       

       

      Basically I get data like this every month and I want to load into a QV to do some totals and stuff. How do I set up the script? Do I just manually load in the data each month. Because I have another ss when I load in my new monthly ss I get $Syn tables

       

      Can anyone suggest anything

      thanks