View Single Post
  #2  
Old May 19th, 2009, 04:22 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default using visio to input datavalues into the already created sql dB/ex

dynamically roundtripping data (to/from visio) requires custom code to be
written.
al


"tushar" wrote in message
...
Is it possible to use the parameters on visio flowsheet/diagram as input
to
an external software/ or sql database?

I want to know that suppose i have a visio flowsheet and i have linked it
to
sql database, is it possible to use this visio flowsheet to function as an
input interface to an external software or even as a point of input to sql
database which will use this data entered for further functioning?

To be clear i would like to state that I want to design a function through
visio to simulate working of a factory, so for that i need to model 'what
if'
kind of scenario. So i want the user to have the flexibility to make
changes
on the flowsheet itself and see what happens if he does so. Hence for that
i
need to dynamaically link the flowsheet data to excel or database, from
where
the simulator product will extract data and make further calculation. the
result of these calculations would have to be displayed on the visio
flowsheet via excel or database.
so basically i need to dynamically export and import data from visio to
excel or database