?
Solved

Importing XML graph from Excel to SQL

Posted on 2011-02-24
1
Medium Priority
?
457 Views
Last Modified: 2013-11-05
We receive Excel sheets containing worksheets with graphs. We want to import the graphs into a SQL server database in a way we can reuse the graphs. For example in a report having the user selecting the graph from the SQL server database. We want to do this in a way we can reformat the graph (only letter type/style and colors).  So we don’t want to store the actual data and we don’t want to reproduce the graph using the report tool itself. Our idea is to save the graph using the XML format. But for us it is unclear at the moment if it is possible to store the Excel graph object using XML in a way we can reproduce the graph using SQL server and reporting services. We are using Excel 2007/2010, SQL server 2008 R2 (including reporting services). Maybe there are other options out there we can use? Please advise
0
Comment
Question by:Netwerkbeheer_AZL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 34970527
I believe you have two options:

1. import data and XML from excel into SQL where you could use XML data type then retrieve it in your app by using your own custom code or into EXCEL again
2. import EXCEL data into SQL and use SSRS to (re)build the reports/graphs
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question