Import iTunes Library into Microsoft Access

[TeenoFilms]

THIS. IS. CONFUSIIIIING!

[TrueElannesse]

Very useful video and certainly good to learn a bit more of Access, thanks for that. But I was hoping that exporting it this way would save the lyrics for the songs and alas, it does not! It's a shame really. It's easier to enable all the columns I need in iTunes when viewing all albums/songs in a list (stuff like file size, bit rate etc), then ctrl+A to select all, then copy and paste the lot into excel sheet. Am I missing important bits of information by doing it this way? Thanx anyway :)

[pchenenko]

This was great! Exactly what I was looking for. I wanted a better way to find my files in the itunes folder on disk (its organization, or lack of, always baffles me). Plus, I'm learning Access and this was a great exercise in creating a crosstab query. Thank you for posting.

[ljbranigan]

This is helpful - but way way too fast!

It has taken me about 10 pause-and-replay's to figure out what you are doing in creating the crosstab query. Slow down mate ! - otherwise you will have a speedy Gonzales clip that no one can follow.

[breuwald]

Thank you for the video! What main purpose are you trying to serve with importing it into access? Is there also a way of importing changed data from access back into the itunes library? Thanks.

[Bliss203]

Good Video. For some reason I'm having problems. I follow the guide just as you explain however in the transfer from Xcel to Access, all of the song titles, albums, etc is not transferred however size and time and things with numerical value get transferred along with the groups and I can't figure out why

[rashlee1]

im the first commet