Take the 2-minute tour ×
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.

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/… –  FreshPhilOfSO May 2 '12 at 11:45
    
Oh thank you, I didn't know. –  answer.42 May 2 '12 at 11:50
add comment

closed as off topic by Leigh Riffel, Aaron Bertrand, FreshPhilOfSO, 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 by the community. 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 reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

Excel is capable of importing XML directly.

See this link for details.

share|improve this answer
add comment

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