Database Export Wizard Problem

[xirx]

Hi!

I am trying to link a shape in an existing drawing to data base, i.e. an
Excel File.
I do:

Tools->Add Ons->Viso Extras->Database Wizard
Next
Select "Link shapes to database records"
Next
Select "Shape(s) in a drawing"
Next
Select a Shape
Next
Select "Excel Files"
Next
Select an Excel File

Now, I get a box in which I am forced to choose a "table". But the selection
list shown is empty. When I try to create a "table" (whereas it is unclear
how the field I define relate to the shape I am going to link to the
external DB), I get an error message, only.

The procedure of linking a shape in an existing drawing is described very
detailed at:

http://www.quepublishing.com/articles/article.asp?p=329051&seqNum=4&rl=1

But I can't get beyond step 7, which is:
"7) Select your database file. Choosing a database object to connect to is
probably best left at the default settings; same with the object types.
Tables and Views should be checked already; Product Reorders should appear
in the Database Objects scroll list. Make sure it's highlighted. Leave the
Define Table button alone and click Next."

My issue is: The "Database Objects scroll list" is empty. I can't click
"Next"...

Any pointers? Any help is very much appriciated.

xirx.

 

[Jagadeesh [MSFT]]

Hi Xirx,

You have to define a "name" in your excel sheet if you want to see the table name in the "Database Wizard".

- In your Excel sheet, select all the cells that are required for linking.

- With the selection highlighted, click on "Insert" menu

- Select "Name" > "Define"; type a name [Example: MyTable] for "Names in workbook" and click OK

- Save and close the excel file.

If you run Database Wizard in Visio after the above given steps, you can see a table name displayed in the Database
Wizard.

Regards,
Jagadeesh. P

--------------------
From: "xirx" <[email protected]>
Newsgroups: microsoft.public.visio
Subject: Database Export Wizard Problem
Date: Wed, 3 May 2006 16:14:01 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
Lines: 45
Message-ID: <[email protected]>
NNTP-Posting-Host: ces-pool151.dtm.ops.eu.uu.net
X-Trace: 1146665642 read.news.de.uu.net 19322 62.191.186.151:2333
X-Complaints-To: (e-mail address removed)
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
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.visio:10998
X-Tomcat-NG: microsoft.public.visio

Hi!

I am trying to link a shape in an existing drawing to data base, i.e. an
Excel File.
I do:

Tools->Add Ons->Viso Extras->Database Wizard
Next
Select "Link shapes to database records"
Next
Select "Shape(s) in a drawing"
Next
Select a Shape
Next
Select "Excel Files"
Next
Select an Excel File

Now, I get a box in which I am forced to choose a "table". But the selection
list shown is empty. When I try to create a "table" (whereas it is unclear
how the field I define relate to the shape I am going to link to the
external DB), I get an error message, only.

The procedure of linking a shape in an existing drawing is described very
detailed at:

http://www.quepublishing.com/articles/article.asp?p=329051&seqNum=4&rl=1

But I can't get beyond step 7, which is:
"7) Select your database file. Choosing a database object to connect to is
probably best left at the default settings; same with the object types.
Tables and Views should be checked already; Product Reorders should appear
in the Database Objects scroll list. Make sure it's highlighted. Leave the
Define Table button alone and click Next."

My issue is: The "Database Objects scroll list" is empty. I can't click
"Next"...

Any pointers? Any help is very much appriciated.

xirx.