Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have some data that is given in a consistent XML format (which I can't change). I would like to import it into a database so that I can work with it, and then search, identify and export certain records into an Excel workbook, as I don't think it can be imported to Excel directly.

I have no experience working with databases so I'm not sure if this is possible or for the best approach. My question is: Can this be done with a database tool/function? It's not important what the database system is, but I would prefer MS-Access or SQL-Server Express.

share|improve this question
1  
Excel can natively import XML. office.microsoft.com/en-us/excel-help/… – Phil May 2 '12 at 11:45
Oh thank you, I didn't know. – answer.42 May 2 '12 at 11:50

closed as off topic by Leigh Riffel, Aaron Bertrand, Phil, Paul White, Martin Smith Nov 4 '12 at 17:55

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

1 Answer

up vote 3 down vote

Excel is capable of importing XML directly.

See this link for details.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.