Best way to automatically generate Visio diagrams

[Francis]

Hello Visio people
I have a product, ControlDraw, which is a diagram based modelling system. People seem to want Visio output, so I am looking into ways to export the diagrams as Visio files. ControlDraw models are databases (Access) and they contain tables and records that define each object that appears on the diagrams, and the connections. So theoretically it should be possible to write a program that will generate equivalent diagrams in Visio.
I have Visual Studio 2010 and (at present) a trial version of Visio 2010. There seem to be many approaches, such as Visio Add-on or just Visio VBA or VS2010 with the Visio SDK
Do you have any recommendations, and code examples that I might see.
See

http://www.controldraw.co.uk/cd1/drawings.htm

for examples of the diagrams

Thanks