Reverse Engineer Wizard in Visio Professional, can't select tables inlast window


J

JRough

I'm trying to create an ERD in Visio 2007 Professional trial. I have
exported each table to a separate Excel sheet.
I am on Windows XP 2002 Professional.
I have Visio Professional 2007.
I have Excel 2007 however I saved the sheets as Excel 97-2003 because
in Visio it appears you can
only connect to Excel 97-2000 datasources? I have the Visio 2007
Professional on order. The first row of each
sheet is the column name.

In
the reverse engineer dialog box it looks like it accepts only Excel
97-2000?

I believe I have some of the sheets set up correctly as datasources
using the generic odbc driver for Excel.
When I keep going through REVERSE ENGINEER dialogs and get to the
"Select tables and or views to
reverse engineer I
don't see any field names in the windows. In fact there is nothing in
the window and it won't let me finish.
When I get to the select object types to reverse engineer it does let
me go on to the next window but as I said
there is nothing to select in the final window.

I want to import each table separately into Visio and have the column
names and table names already there for me.
Am I doing it right? and why does it expect only Excel97-2000? If I
saved it as Excel95-2003 would that be the problem.

tia,
 
Ad

Advertisements

B

Barb Way

I thinnk this may have been addressed elsewhere - but just to be sure,
there is no Visio Database Modeling for Excel. Only relational databases
can be connected to for modeling purposes. There are Visio wizards (such
as the Organization Chart) which can connect to ODBC sources such as Excel
to import the data - but we do not model the Schema (Structure) of any
source except a true Database.


Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

I'm trying to create an ERD in Visio 2007 Professional trial. I have
exported each table to a separate Excel sheet.
I am on Windows XP 2002 Professional.
I have Visio Professional 2007.
I have Excel 2007 however I saved the sheets as Excel 97-2003 because
in Visio it appears you can
only connect to Excel 97-2000 datasources? I have the Visio 2007
Professional on order. The first row of each
sheet is the column name.

In
the reverse engineer dialog box it looks like it accepts only Excel
97-2000?

I believe I have some of the sheets set up correctly as datasources
using the generic odbc driver for Excel.
When I keep going through REVERSE ENGINEER dialogs and get to the
"Select tables and or views to
reverse engineer I
don't see any field names in the windows. In fact there is nothing in
the window and it won't let me finish.
When I get to the select object types to reverse engineer it does let
me go on to the next window but as I said
there is nothing to select in the final window.

I want to import each table separately into Visio and have the column
names and table names already there for me.
Am I doing it right? and why does it expect only Excel97-2000? If I
saved it as Excel95-2003 would that be the problem.

tia,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top