Sage 50 Canadian comes with a set of Excel and Word templates that use VBA to extract data from a Sage 50 company 'file' database.

There are formatting instructions in the VBA code you could look at, as an example.  

But I suppose it's past your deadline now, even if you're in Europe.