Discussion:
Visio 2003: Import data from Excel?
(too old to reply)
Stefan Lasiewski
2008-07-10 01:10:00 UTC
Permalink
I am creating a network diagram.

I have an Excel 2003 spreadsheet which contains the hostnames, serial
numbers & other information for many machines. Is it possible to link
these fields to the shapes in a Visio diagram?

I've done this using the online demo of Excel 2007. Is this possible
to do in Excel 2003?

I can't find any information about this in the help file. Can anyone
point me to a tutorial?

Thank you,

-= Stefan
AlEdlund
2008-07-10 10:24:18 UTC
Permalink
more importantly than the version of excel is the version of visio. The
demos are typically visio 2007 professional.
http://office.microsoft.com/training/training.aspx?AssetID=RC101977211033
al
Post by Stefan Lasiewski
I am creating a network diagram.
I have an Excel 2003 spreadsheet which contains the hostnames, serial
numbers & other information for many machines. Is it possible to link
these fields to the shapes in a Visio diagram?
I've done this using the online demo of Excel 2007. Is this possible
to do in Excel 2003?
I can't find any information about this in the help file. Can anyone
point me to a tutorial?
Thank you,
-= Stefan
Stefan Lasiewski
2008-07-10 17:35:25 UTC
Permalink
I am using Visio 2003 standard. Sorry I didn't make that clear.

It looks like this ability was added back to Visio 2007. Is this
feature just in Visio 2007 professional, or does it exist in Visio
2007 standard edition?

I vaguely remember that years ago, I was able to import a CSV (or
spreadsheet) into Visio 2000 or Visio 2002. I also remember surveying
a lan using SNMP, and using that data to populate a network diagram.
It's been a while, so maybe I don't remember correctly.

However, it looks like some of these abilities were removed from Visio
2003:

http://office.microsoft.com/en-us/visio/HA010857571033.aspx?pid=CH010326821033
http://office.microsoft.com/en-us/visio/HA010935581033.aspx?pid=CH010326821033

Thanks for your help!

-= Stefan
Roberto
2008-07-29 19:03:02 UTC
Permalink
I believe is just a business
Microsoft must be a update visio 2003 to avoid purchase Visio 2007
Post by Stefan Lasiewski
I am using Visio 2003 standard. Sorry I didn't make that clear.
It looks like this ability was added back to Visio 2007. Is this
feature just in Visio 2007 professional, or does it exist in Visio
2007 standard edition?
I vaguely remember that years ago, I was able to import a CSV (or
spreadsheet) into Visio 2000 or Visio 2002. I also remember surveying
a lan using SNMP, and using that data to populate a network diagram.
It's been a while, so maybe I don't remember correctly.
However, it looks like some of these abilities were removed from Visio
http://office.microsoft.com/en-us/visio/HA010857571033.aspx?pid=CH010326821033
http://office.microsoft.com/en-us/visio/HA010935581033.aspx?pid=CH010326821033
Thanks for your help!
-= Stefan
David Parker
2008-07-10 12:28:09 UTC
Permalink
No problem with Exce 2003 (I assume you have Visio 2007 Pro)
Post by Stefan Lasiewski
I am creating a network diagram.
I have an Excel 2003 spreadsheet which contains the hostnames, serial
numbers & other information for many machines. Is it possible to link
these fields to the shapes in a Visio diagram?
I've done this using the online demo of Excel 2007. Is this possible
to do in Excel 2003?
I can't find any information about this in the help file. Can anyone
point me to a tutorial?
Thank you,
-= Stefan
--
David Parker
Microsoft MVP (Visio)
http://bvisual.spaces.live.com
http://www.visualizinginformation.com
unknown
2010-02-09 12:51:48 UTC
Permalink
Microsoft Office Visio 2007 diagrams turn complicated ideas, text, and tables into easy-to-understand visuals that communicate information at a glance. Real-time data Embed together and programs in Visio from a word doc will translate into visual Aero Glass effects, themes, and transparencies.
http://bit.ly/4Dij15



David Parker wrote:

No problem with Exce 2003 (I assume you have Visio 2007 Pro)"Stefan Lasiewski"
10-Jul-08

No problem with Exce 2003 (I assume you have Visio 2007 Pro)


--
David Parker
Microsoft MVP (Visio)
http://bvisual.spaces.live.com
http://www.visualizinginformation.com

Previous Posts In This Thread:

On Thursday, July 10, 2008 6:24 AM
AlEdlund wrote:

more importantly than the version of excel is the version of visio.
more importantly than the version of excel is the version of visio. The
demos are typically visio 2007 professional.
http://office.microsoft.com/training/training.aspx?AssetID=RC101977211033
al

On Thursday, July 10, 2008 8:28 AM
David Parker wrote:

No problem with Exce 2003 (I assume you have Visio 2007 Pro)"Stefan Lasiewski"
No problem with Exce 2003 (I assume you have Visio 2007 Pro)


--
David Parker
Microsoft MVP (Visio)
http://bvisual.spaces.live.com
http://www.visualizinginformation.com

On Friday, July 11, 2008 9:57 PM
Stefan Lasiewski wrote:

Visio 2003: Import data from Excel?
I am creating a network diagram.

I have an Excel 2003 spreadsheet which contains the hostnames, serial
numbers & other information for many machines. Is it possible to link
these fields to the shapes in a Visio diagram?

I've done this using the online demo of Excel 2007. Is this possible
to do in Excel 2003?

I can't find any information about this in the help file. Can anyone
point me to a tutorial?

Thank you,

-= Stefan

On Friday, July 11, 2008 9:57 PM
Stefan Lasiewski wrote:

I am using Visio 2003 standard. Sorry I didn't make that clear.
I am using Visio 2003 standard. Sorry I didn't make that clear.

It looks like this ability was added back to Visio 2007. Is this
feature just in Visio 2007 professional, or does it exist in Visio
2007 standard edition?

I vaguely remember that years ago, I was able to import a CSV (or
spreadsheet) into Visio 2000 or Visio 2002. I also remember surveying
a lan using SNMP, and using that data to populate a network diagram.
It's been a while, so maybe I don't remember correctly.

However, it looks like some of these abilities were removed from Visio
2003:

http://office.microsoft.com/en-us/visio/HA010857571033.aspx?pid=CH010326821033
http://office.microsoft.com/en-us/visio/HA010935581033.aspx?pid=CH010326821033

Thanks for your help!

-= Stefan

On Tuesday, July 29, 2008 3:03 PM
Robert wrote:

I believe is just a business Microsoft must be a update visio 2003 to avoid
I believe is just a business
Microsoft must be a update visio 2003 to avoid purchase Visio 2007

"Stefan Lasiewski" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint - Managing Unused or Archive sites automatically
http://www.eggheadcafe.com/tutorials/aspnet/96bf1f1c-ab6f-43f1-9a5b-a2a8deb60cad/sharepoint--managing-unu.aspx
Loading...