Append records to an Excel Table RRS feed

  • Question

  • I have a Power Querie that extracts data from emails that are sent by a telemetrie system.

    I can convert the data in the mails, merge with other databases and get an Excel table with all the data.

    Problem is that every day all emails need to be read, converted to make the Excel table; if one email is removed from the mailbox the data will be missing.

    I want to make an append of the newest data processed to an Excel table (eg 'processed data'), without changing (re-processing) the previous data.

    If I try the power query 'append' then I can create a new table with the old & new data but the next day I can't use the 'processed data' as input for the append?

    Thanks in advance for any advice.

    Rgds, Dirk.

    Monday, May 23, 2016 3:58 PM


All replies