I have a workbook which I have set up a connection to import data from a CSV file. Upon refresh, it is set up for the user to choose the file they want to import. I would like the newly imported data to append to the existing worksheet. The idea was to import data from several days and then create reports/pivot tables for the data to show activity over time. I do want to avoid copying and pasting data, if at all possible. I thought there was an option in the import wizard to do this, but everything I've done seems to just bring in the new data and deletes the old data.
Any help would be appreciated. Thanks a million.
Any help would be appreciated. Thanks a million.
