RE: Database Export Wizard Problem

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hi Xirx,
\par
\par You have to define a "name" in your excel *** if you want to see the table name in the "Database Wizard".
\par
\par - In your Excel ***, select all the cells that are required for linking.
\par
\par - With the selection highlighted, click on "Insert" menu
\par
\par - Select "Name" > "Define"; type a name [Example: MyTable] for "Names in workbook" and click OK
\par
\par - Save and close the excel file.
\par
\par If you run Database Wizard in Visio after the above given steps, you can see a table name displayed in the Database Wizard.
\par
\par Regards,
\par Jagadeesh. P
\par
\par \pard\li720 --------------------
\par From: "xirx" <xirx@xxxxxx>
\par Newsgroups: microsoft.public.visio
\par Subject: Database Export Wizard Problem
\par Date: Wed, 3 May 2006 16:14:01 +0200
\par X-Priority: 3
\par X-MSMail-Priority: Normal
\par X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
\par X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
\par X-RFC2646: Format=Flowed; Original
\par Lines: 45
\par Message-ID: <4458baaa$0$19322$4d4ebb8e@xxxxxxxxxxxxxxxxxxx>
\par NNTP-Posting-Host: ces-pool151.dtm.ops.eu.uu.net
\par X-Trace: 1146665642 read.news.de.uu.net 19322 62.191.186.151:2333
\par X-Complaints-To: abuse@xxxxxxxxx
\par Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.cw.net!cw.net!news-FFM2.ecrc.de!uio.no!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsinpeer00.lnd.ops.eu.uu.net!bnewsinpeer00.bru.ops.eu.uu.net!emea.uu.net!read.news.de.uu.net!not-for-mail
\par Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.visio:10998
\par X-Tomcat-NG: microsoft.public.visio
\par
\par Hi!
\par
\par I am trying to link a shape in an existing drawing to data base, i.e. an
\par Excel File.
\par I do:
\par
\par Tools->Add Ons->Viso Extras->Database Wizard
\par Next
\par Select "Link shapes to database records"
\par Next
\par Select "Shape(s) in a drawing"
\par Next
\par Select a Shape
\par Next
\par Select "Excel Files"
\par Next
\par Select an Excel File
\par
\par Now, I get a box in which I am forced to choose a "table". But the selection
\par list shown is empty. When I try to create a "table" (whereas it is unclear
\par how the field I define relate to the shape I am going to link to the
\par external DB), I get an error message, only.
\par
\par The procedure of linking a shape in an existing drawing is described very
\par detailed at:
\par
\par http://www.quepublishing.com/articles/article.asp?p=329051&seqNum=4&rl=1
\par
\par But I can't get beyond step 7, which is:
\par "7) Select your database file. Choosing a database object to connect to is
\par probably best left at the default settings; same with the object types.
\par Tables and Views should be checked already; Product Reorders should appear
\par in the Database Objects scroll list. Make sure it's highlighted. Leave the
\par Define Table button alone and click Next."
\par
\par My issue is: The "Database Objects scroll list" is empty. I can't click
\par "Next"...
\par
\par Any pointers? Any help is very much appriciated.
\par
\par xirx.
\par
\par
\par
\par
\par \pard
\par
\par }