Reverse of export to database

[Jan DOUMEN]

Ave,

I would like to generate a Visio drawing starting from an Access
database which contains the results of an 'export to database' of an
existing drawing. I found import possibilities from Excel, csv, txt
files, but not from databases. I'm using Visio 2002 Professional.

Greetings,

 

[RA]

Are you trying to import the data from the database tables or the database
schema?

If it is the database schema, run the Database modeling template (File \ New
\ Database \ Database model diagram)
If you want to get the data, try the "Link to Database" dialog (Tools \
Macros \ Visio Extras \ Link to Database)
You can import from a DSN.

 

[RA]

Getting Visio to draw the shapes on the diagram as the Database records are
populated would require some custom VBA macro code. Visio does not have
built-in functionality to dynamically draw the shapes like that.

It is do-able and shouldnt be too hard.
Once your database records are populated, the macro can use ADO or ODBC to
access the database.
Get the data and put them into a shape and instantiate the shape on the
page.

--
-ronnie
[MS]
This posting is provided "AS IS" with no warranties, and confers no rights.

"RA" <[email protected]> wrote in message

Ronnie,

during an export, a table is created with data in it describing the
shapes. Something like:

ShapeKey Width Height Angle FlipX FlipY PinX PinY LocPinX LocPinY

ResizeMode LinePattern LineWeight LineColor LineCap BeginArrow
BeginArrowSize EndArrow EndArrowSize Rounding FillPattern FillForegnd
FillBkgnd ShdwPattern ShdwForegnd ShdwBkgnd BeginX EndX BeginY EndY
ShapeText ShapeData1 ShapeData2 ShapeData3