Reverse Engineer from Excel

Started by collierd, March 27, 2015, 01:16:54 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

collierd

Hello

Does anybody know how reverse engineering works within Visio 2007
I'm trying to reverse engineer a number of tables

Currently, I can only create entities with a name plus some columns

How do I auto-create joins?

Thanks

Surrogate

#1
if you need works with tables in visio try use VisioTablesAddin by Shisok

Sorry, i don't know what mean Reverse Engineer

Nikolay

Quote from: collierd on March 27, 2015, 01:16:54 PM
Does anybody know how reverse engineering works within Visio 2007

Hmm.. This is pretty well documented by Microsoft in the manual.. what do you mean?
https://support.office.com/en-za/article/Reverse-engineer-an-existing-database-into-a-database-model-fb034862-acfc-45bc-88b2-f33d1e1f8614#

There are numerous Videos also:
https://www.youtube.com/results?search_query=visio+reverse+engineer

Quote
I'm trying to reverse engineer a number of tables
Currently, I can only create entities with a name plus some columns
How do I auto-create joins?

It sounds like you are having some issue with reverse engineer? (i.e. it does not work as it should?) or?
In this case, we may need a bit more information.. Like, what type of the database are you reverse-engineering? MS SQL? Oracle? Something else?
And the relations (PKs/FKs) are not imported by the wizard? or?

Common pain point is an issue when trying to reverse engineer SQL SERVER 2008 (or above) database with Visio 2007 (just shooting in the dark of course..)
The solution to this issue: do not select "Microsoft SQL Server" as provider when doing reverse-engineer, but select "ODBC Generic Driver" or "Generic OLEDB Provider" instead.

Nikolay

#3
Ups. Sorry. Did not read properly the CAPTION of the topic. Silly me.

EXCEL! You are reverse-engineering EXCEL! :)

But are there even relations in Excel?! Like primary keys or foreign keys?
Normally these joins are supposed to be those (PKs/FKs). But does Excel really have something like this..?
I.e. what kind of "table relationships" you are going to display using these joins/arrows, if it's about Excel? Table relationships simply do exist in Excel, do they..?