Have SQL data populate a grid in Visio
Posted on 2010-08-22
This is a long shot but I wanted to know if it was possible to do the following;
We have supermarkets that we work in and we 'floor plan' these before we start working and map out where all the locations of the blocks are, it's a handy tool for our guys to find what they need to in the stores. What I would like to do is have the grid on a visio page so; A1-ZZ99 (for instance) and if I have an entry in my DB for grid reference B20 (for instance), it colours that little block in in whatever I choose, or highlights it somehow.
This is just a question to you all to see if it's possible to do this type of thing and if not do you know anyway this could be achieved?
Any help would be much appreciated.