Forum Discussion
Appending tables
Currently I am I have sales data for the past 24 months in seperate files becuase of there size and wanting to roll them off on a 24 month calender. I append those files in a desktop query so tha...
If your files are local, then you will need to use a gateway such as the Personal Gateway or Enterprise Gateway. Once you install one of these and it authenticates to the Service, the Service can refresh your queries automagically.
Ok, but if i build the report in desktop will i not also need to update the desktop file with the new data before the service will?
And if I build the report in the service then all I have to do is schedule the data file to refresh, Correct?