I have a data muncher which could export Excel data. There is this SystemHigh demanding data echange via Excel and they provide template file for that. It is worth nothing that fields and their formats do not pass exactly, some routine work needs to be done.
What i do is i open my muncher’s exported file, drag Sheet to the Base Table section and use data from a Query where fields are formatted/ordered in a sequence like in SH template file. This then satisfies SH demand.
In order to work on a next data exchange i would need to Delete Table from base, open a new source Excel file and drag the Sheet to the Base/Tables again.
If there was a possibility to DDE data from Excel source to the Base that would allow for to simple source file owerwrite.
Is there any? So far my G-fu fails.