How to import iTunes XML library into MS Acess database?

Question

Level 1

35 points

How to import iTunes XML library into MS Acess database?

I have exported my iTunes data to a library XML file. When I try to import these data to a MS Access database (without the sound files of course) I only get strange and stupid table entries.
I would like to use MS Access to create more flexible reports of my music collection.
Has anyone ever imported iTunes XML files into MS Access successfully?

P.S. An import solution to OpenOffice.org as alternative is also appreciated.

iMac G5 (17, 1.8GHz), Mac OS X (10.4.5)

Posted on Feb 27, 2006 1:13 AM

Reply

Answer 1

Otto42

Level 6

9,070 points

Feb 27, 2006 11:55 AM in response to Thomas A.

In iTunes, you can "Export Song List" and one of the other options is to export as a text file. This actually creates a comma or tab separated values file, which is a lot easier to import into Microsoft stuff than the XML file is.

Reply

Answer 2

Thomas A. Author

Level 1

35 points

Feb 28, 2006 2:53 AM in response to Otto42

Thanks, that was a very good tip. It really works fine, and the text file is indeed easier to handle with other applications. Thanks again.

Reply