I have this same situation. Data comes in daily in the same format. How can I append the new data and get the full date range?
I was able to solve this. Here's how:
1. Connect to first data source.
2. Right click on first data source, mouse over Extract
3. Click Add Data from File...
4. Navigate to additional data source and connect