I am importing a report of invoices that were processed in the AP accounting system. I am parsing the report down to real data (that to all that helped with suggestions to make this work). And it is working very nicely. After the data is parsed I can create a summary report of the batch number within the data, with the total number of invoices processed per batch and the total dollars per batch.
What I am wanting to do now is move those information on that summary report to a table in the file. I have moved detail records from one table to another. However, not summary. Do I need to export the summary data to a temp table, and import from there to the final table, or can I append in an export the summary records?