[Create ERD in Visio] Reverse Engineer Wizard   

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

date: Thu, 29 May 2008 13:20:15 -0700 (PDT)   author:   JRough

RE: [Create ERD in Visio] Reverse Engineer Wizard   

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs26 Please see response in the duplicate post.
\par 
\par Barb Way
\par Product Support - Visio
\par Microsoft Corporation
\par [This posting is provided "As Is" with no warranties, and confers no rights.]
\par \pard\li720 --------------------
\par From: JRough 
\par Newsgroups: microsoft.public.visio
\par Subject: [Create ERD in Visio] Reverse Engineer Wizard
\par Date: Thu, 29 May 2008 13:20:15 -0700 (PDT)
\par Organization: http://groups.google.com
\par Lines: 20
\par Message-ID: 
\par NNTP-Posting-Host: 67.100.94.131
\par Mime-Version: 1.0
\par Content-Type: text/plain; charset=ISO-8859-1
\par Content-Transfer-Encoding: 7bit
\par X-Trace: posting.google.com 1212092416 29564 127.0.0.1 (29 May 2008 20:20:16 GMT)
\par X-Complaints-To: groups-abuse@google.com
\par NNTP-Posting-Date: Thu, 29 May 2008 20:20:16 +0000 (UTC)
\par Complaints-To: groups-abuse@google.com
\par Injection-Info: x19g2000prg.googlegroups.com; posting-host=67.100.94.131; 
\par \tab posting-account=ncteIwoAAABHIM8FpuT6bIJhn1uQznef
\par User-Agent: G2/1.0
\par X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) 
\par \tab Gecko/20080404 Firefox/2.0.0.14,gzip(gfe),gzip(gfe)
\par Bytes: 1774
\par Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!x19g2000prg.googlegroups.com!not-for-mail
\par Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.visio:2086
\par X-Tomcat-NG: microsoft.public.visio
\par 
\par I'm trying to create an ERD in Visio from exported tables from MySQL.
\par I exported each table to Excel.  I am on Windows XP 2002
\par Professional.  I have Visio Professional 2007.  I have Excel 2007
\par however I saved the
\par sheets as Excel 97-2003.
\par 
\par  In
\par the reverse engineer dialog box it looks like it accepts Excel
\par 97-2000?
\par I think I have Visio connected to one of the sheets as a datasource
\par using the generic odbc driver for Excel.
\par Each sheet is one table.  When I keep going through the dialogs I
\par don't see any field names in the windows where it says select tables/
\par views  there is nothing to select.
\par 
\par 
\par 
\par tia
\par 
\par     Reply    Reply to author    Forward
\par \pard 
\par 
\par }

date: Fri, 30 May 2008 00:55:18 GMT   author:   (Barb Way)