Author Topic: Reverse Engineer from Excel  (Read 2609 times)

0 Members and 1 Guest are viewing this topic.

collierd

  • Newbie
  • *
  • Posts: 3
Reverse Engineer from Excel
« on: March 27, 2015, 08:16:54 AM »
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

  • Hero Member
  • *****
  • Posts: 891
    • ShapeSheet™ Knowledge Base
Re: Reverse Engineer from Excel
« Reply #1 on: March 27, 2015, 08:41:58 AM »
if you need works with tables in visio try use VisioTablesAddin by Shisok

Sorry, i don't know what mean Reverse Engineer
« Last Edit: March 27, 2015, 08:43:32 AM by Surrogate »

Nikolay

  • Hero Member
  • *****
  • Posts: 773
    • UnmanagedVisio
Re: Reverse Engineer from Excel
« Reply #2 on: March 27, 2015, 12:22:30 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

  • Hero Member
  • *****
  • Posts: 773
    • UnmanagedVisio
Re: Reverse Engineer from Excel
« Reply #3 on: March 27, 2015, 12:30:17 PM »
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..?
« Last Edit: March 27, 2015, 01:03:41 PM by Nikolay »