Managing XML - Creating XSD's and db management

[sayth]

I am really looking how to master consistently and reliably manage insert, store and retrieve data. A lot of data I am getting is in XML format.

Is there a way in Excel to create an XSD from an XML file so that I can import the file honouring and utilising its tabular structure?

It would then make it easy to push the data(hopefully) into SQL server or MySQL and retrieve the data back into my reports and dashboards.

Can anyone offer advice on this or has done this before reliably?

 

[NARAYANK991]

Hi ,

Can you detail your requirement ?

1. Your input data is in the form of one or more XML files.

2. You wish to take this data into SQL Server or MySQL.

You also talk of using Excel to create XSD files , and retrieving data from SQL Server / MySQL into your reports and dashboards. I presume your dashboards are in Excel.

I am not able to connect items 1 and 2 with the rest of it ; can you give some more information on this ?

In the meantime , see if this helps :

http://www.mssqltips.com/sqlservert...g-data-from-xml-files-into-sql-server-tables/

Narayan

 

[sayth]

I will be tracking a state sporting bodies xml they post a pre event and post event XML file for each event.

I think XML maps in Excel may allow me to ensure my XML file imports are accurate each time, rather than creating an XSD for it first. I was initially going to use MYSQL because of the nice Excel plugin they have, however going straight to MSSQL may be a better option and then just connect to the db from excel.

I really am just trying to create a repeatable and accurate data import process to use with Excel. Going to read your link further now.