Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there and welcome
Can you tell me please what you mean with External Data Bill?
Is it data in another Visio file you do not have access to?
If you go to the view tab and select the external data window. I can see 5 tables in the window below. Tables, Dictionary, Relations, Indexes and module-tables. I don't have access to the external data using to populate these but would like to get the data into a excel/csv file so that I can review it and match to my other data sources for accuracy and completeness.
Can you provide me the file Bill so I can check it please.
Attach it to this question please.
Sorry it is confidential
ok, if you do not have access to the data, you cannot batch export it, but can you select the Text?
If so you would need to select and copy the data then paste it into Excel.
Does not work at the best I get the Visio drawing and that's it.
ok, then it will not be possible, if the data is not selectable it mans it has not locally cached it.
The only way would be to have the actual external data
The raw data must be in Visio because if I select a column heading and click on it the data is sorted by that column heading also I can modify what columns that are displayed..
It is table structure data from a MS SQL database that Visio used to create the ERD drawing..
All data that can be selected and copied to Excel is what you can see and select, which is why I gave the instructions to select the data and copy and paste it.
If your not able to even select and copy it then you will not be able to export it to excel, its the method to copy the data to excel.
Found the window to refresh the data and as I though since I am not connect to their database it can't connect.. Could it be that I am running to old a version of Visio 2007?
No, its because it does not have access to the database, this is why it will not be able to connect to it.
Found this going to try it later this week.
ok, it would help Bill if I could see the data, but as you see in that script they can copy the data from it but sometimes get bad data from it