View Single Post
  #1  
Old May 19th, 2009, 07:39 AM posted to microsoft.public.visio.general
Tushar
external usenet poster
 
Posts: 7
Default using visio to input datavalues into the already created sql dB/ex

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