V
Vondre Daniel
How can visio extract data from an internal database?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
junethesecond
Is this post duplicated?
V
Vondre Daniel
No, I don't think so.
A
Al Edlund
could you help us understand how you are differentiating between internal
and external databases?
TIA,
Al
and external databases?
TIA,
Al
V
Vondre Daniel
Sorry if I'm confusing you! I'm confused which is why I need help. I'm trying
to link my shapes in my drawing to an existing SQL Server db. I want to be
able to click on my shapes and query the db for data which I will have in vba
code behind the scene. Any solutions?
to link my shapes in my drawing to an existing SQL Server db. I want to be
able to click on my shapes and query the db for data which I will have in vba
code behind the scene. Any solutions?
A
Al Edlund
yes it is definitely doable with vba. as far as a working example I haven't
seen one. For my code (which points at Access) I've used ADO calls. One of
the resources you might consider is the Script Center on
technet.microsoft.com because vbscript is very close to vba and they have
some examples on how to connect to sql.
Al
seen one. For my code (which points at Access) I've used ADO calls. One of
the resources you might consider is the Script Center on
technet.microsoft.com because vbscript is very close to vba and they have
some examples on how to connect to sql.
Al
V
Vondre Daniel
Thanks for the information!
Al Edlund said:yes it is definitely doable with vba. as far as a working example I haven't
seen one. For my code (which points at Access) I've used ADO calls. One of
the resources you might consider is the Script Center on
technet.microsoft.com because vbscript is very close to vba and they have
some examples on how to connect to sql.
Al