Advertisement

09.15.2007 at 09:30AM PDT, ID: 22830931
[x]
Attachment Details

Visio, Excel, Access. Diagrams, IT inventory list.

Asked by romlopez in Microsoft Visio, Microsoft Access Database, Microsoft Excel Spreadsheet Software

Tags: visio, inventory, excel, access, diagram

Background:
All 50 Dell PC's, only 1 HP laptop.
MS Office 2003.
I have an excel sheet with all the IT inventory from the company. (PC Make, model, service tag, express svc code, processor type/speed, BIOS version, RAM type/amount, etc)
I also have a Visio network Diagram with the computer locations.
If I have to redo the excel sheet or the Visio diagram it's fine.....

I would like to somehow create an excel list with all the inventory (kind of what I have now) which is connected to the Visio diagram and showing up-to-date information from the excel sheet.
Example: I have a drawing of a PC in Visio and in the comment area is showing information from the excel sheet such as service tag #.
Or connected to an Access database?
Is this even possible?

Or is there any better solution (for free)?Start Free Trial
[+][-]09.16.2007 at 08:24PM PDT, ID: 19902731

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Visio, Microsoft Access Database, Microsoft Excel Spreadsheet Software
Tags: visio, inventory, excel, access, diagram
Sign Up Now!
Solution Provided By: puppydogbuddy
Participating Experts: 2
Solution Grade: B
 
 
[+][-]09.26.2007 at 07:47AM PDT, ID: 19963506

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]10.29.2007 at 09:06AM PDT, ID: 20170642

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628