[AccessD] cataloguing mp3 albums

Bless you. It will probably be tomorrow before I send it. I've got 3 "books" of cd's altogether and have finished ripping one, have another one and a half books to go.

I'll enjoy looking at the code of how you do it, and learning from it. BTW, I've got A2k, but can always convert 97 if that's what you have.

Thank you,

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net  

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of dave sharpe
> Sent: 13 Sep 2003 6:56:PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] cataloguing mp3 albums
> 
> 
> Kathryn
> 
> I feel that it would be simple to do, but would be tedious to explain how.
> 
> If you'd post the complete list; I'll do it and return an mdb with the code
> that I write to do it.
> 
> Dave
> 
> 
> ----- Original Message ----- 
> From: "Kathryn Bassett" <kathryn at bassett.net>
> To: "dbAdvisors (AccessD)" <accessd at databaseadvisors.com>
> Sent: Saturday, September 13, 2003 9:37 PM
> Subject: [AccessD] cataloguing mp3 albums
> 
> 
> > Got one that I haven't a clue about trying to convert. I've got a text
> report (about 50 albums of varying numbers of tracks) Sorry for length of
> message but I wanted to put in several to show you the general patterns of
> the data.
> >
> > Now, what I want is to have a query (or series of queries) put this into
> Access as a database. It only has to be done once, one I'm finished ripping
> all my CDs, as any new ones I don't mind entering by hand. I want to be able
> to print a report that would be in order similar to below, plus a report in
> order by title of the track, with what album it is on and the track number,
> and lastly, by the artist, sub-ordered by track then album, also album then
> track. I feel confident I can do the queries and reports, but need one of
> you to help me with turning the text to tables. I do notice that I've got
> some natural breaks, to break the components apart - the period for the
> track number, the first - is the split between song title and the artist,
> and the ( ) for the time track (which I do want). Note that Simon and
> Garfunkel have a second - that might cause a problem, but when I've got the
> final text file, I can eliminate those easily before doing the conversion.
> >
> > So, any volunteers to help?
<snip>