[Create ERD in Visio] Reverse Engineer Wizard

[JRough]

I'm trying to create an ERD in Visio from exported tables from MySQL.
I exported each table to Excel. 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.

In
the reverse engineer dialog box it looks like it accepts Excel
97-2000?
I think I have Visio connected to one of the sheets as a datasource
using the generic odbc driver for Excel.
Each sheet is one table. When I keep going through the dialogs I
don't see any field names in the windows where it says select tables/
views there is nothing to select.



tia

Reply Reply to author Forward

 

[Barb Way]

Please see response in the duplicate post.

Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------
From: JRough <[email protected]>
Newsgroups: microsoft.public.visio
Subject: [Create ERD in Visio] Reverse Engineer Wizard
Date: Thu, 29 May 2008 13:20:15 -0700 (PDT)
Organization: http://groups.google.com
Lines: 20
Message-ID:
<15cf8b6a-6e02-430b-826b-cba63d23028f@x19g2000prg.googlegroups.com>
NNTP-Posting-Host: 67.100.94.131
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1212092416 29564 127.0.0.1 (29 May 2008
20:20:16 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Thu, 29 May 2008 20:20:16 +0000 (UTC)
Complaints-To: (e-mail address removed)
Injection-Info: x19g2000prg.googlegroups.com; posting-host=67.100.94.131;
posting-account=ncteIwoAAABHIM8FpuT6bIJhn1uQznef
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.8.1.14)
Gecko/20080404 Firefox/2.0.0.14,gzip(gfe),gzip(gfe)
Bytes: 1774
Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed0
0.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.co
m!postnews.google.com!x19g2000prg.googlegroups.com!not-for-mail
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.visio:2086
X-Tomcat-NG: microsoft.public.visio

I'm trying to create an ERD in Visio from exported tables from MySQL.
I exported each table to Excel. 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.

In
the reverse engineer dialog box it looks like it accepts Excel
97-2000?
I think I have Visio connected to one of the sheets as a datasource
using the generic odbc driver for Excel.
Each sheet is one table. When I keep going through the dialogs I
don't see any field names in the windows where it says select tables/
views there is nothing to select.



tia

Reply Reply to author Forward