It sounds like you have mixed two solutions together, the Organization
Wizard and the Database Wizard. The Organization Wizard will allow you to
import/export information from a Visio drawing to a data source such as
ODBC, Excel or Exchange. Note with Visio 2007 you have Excel as one of the
sources use that one. The Database Wizard allows you to export/import and
link data information in a drawing to data sources. Note this is older
technology which originated before 2007. The Organization Wizard does not
allow you link your data and update it dynamically. If you add new people
to the Visio drawing then you can export this information to a data source
such as Excel, note there is a certain structure which is needed in order
for Visio to recognize the information. If you change the information in
the Excel sheet then you will need to import this information back into
Visio and create a new chart.
James W.
--------------------
From: (e-mail address removed)
Newsgroups: microsoft.public.visio.general
Subject: Can't update org chart with added records (ODBC error)
Date: Thu, 24 Jul 2008 19:34:50 -0700 (PDT)
Organization:
http://groups.google.com
Lines: 15
Message-ID:
<97517e06-e14d-4353-9420-2764c192841c@v39g2000pro.googlegroups.com>
NNTP-Posting-Host: 137.219.45.148
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1216953290 21328 127.0.0.1 (25 Jul 2008
02:34:50 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Fri, 25 Jul 2008 02:34:50 +0000 (UTC)
Complaints-To: (e-mail address removed)
Injection-Info: v39g2000pro.googlegroups.com; posting-host=137.219.45.148;
posting-account=VqmR9AoAAAAludQ7BnOsgyMY9LIuFm4t
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.9.0.1)
Gecko/2008070208 Firefox/3.0.1 Creative ZENcast
v2.01.01,gzip(gfe),gzip(gfe)
Bytes: 1882
Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!TK2MSFTFE
EDS01.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.gigane
ws.com!nntp.giganews.com!postnews.google.com!v39g2000pro.googlegroups.com!no
t-for-mail
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.visio.general:8746
X-Tomcat-NG: microsoft.public.visio.general
Hi there. I have a Visio (2007) organization chart created with the
wizard using an Excel spreadsheet and the ODBC method. When I update
the details in the sheet and then in Visio choose "Refresh Shape
Data", it works fine. When I add a (valid) record to the Excel sheet
(still within the named region) and choose "Update Linked Records", it
takes a while, then gives me the error:
Database Wizard Error
Run the Database Wizard and re-link the shape to correct the problem.
ODBC Error: 23000
[Microsoft][ODBC Excel Driver] Cannot update '(expression)'; field not
updateable.
Can anyone help me fix this?
I need to be able to update the chart to show new people as they are
added and that sort of thing.
