Hello,
I suppose you have one .bak file and not many (with a numerical extension, like .bak01), that is, all entries are coming from the same Sage CRM table. If the file had been created from more than one tables, then we have to create more than one Excel tables, associating them in a manner similar to the one used in Sage CRM. Could it be possible to send me the .bak file?
A few words about me: I'm developing VBA programs for more than 15 years and I'm an Excel and VBA trainer for 12+ years. As you can guess, I have created a plethora of tables, macros, reports, etc.. of any kind, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini