Thx heaps chuck, I'll get strait on it after my new year hangover.
reg's
Mark.
"Chuck Grimsby" <c.grimsby@worldnet.att.net.invalid> wrote in message
news:7mmnq157sfendlo8jq0ekbcn08dabb00u1@4ax.com...[color=blue]
>
> Check out the Tag & Rename program. It will do exactly that!
>
>
http://www.softpointer.com/tr.htm
>
> I think it's about $25.
>
> If you want to do it all inside Access, there are a couple of MP3
> class files on the web that can do this, but the tag&rename program is
> a lot nicer to use, and has a bunch of nice features already built-in
> that you won't have to program in.
>
> I have the Tag&&Rename program myself (I'm a user, I didn't write it)
> and use it for editing the tags and exporting the tag information to a
> CSV, then I import the data into my MP3 Database in Access/SQL.
>
> I spent quite a bit of time doing it all myself with my own code, but
> in the end it was just easier and simpler to do it with the Tag&Rename
> program (which will also link up with a couple of CD Libraries on the
> web and grab information for you.)
>
> On Fri, 23 Dec 2005 20:30:49 +1100, "NoodNutt"
> <noodnutt@iprimus.com.au> wrote:[color=green]
>>Thx for replying, I actually have imported all the file names already, I
>>was
>>hoping there was a way of extracting the tagged info that accompanies mp3
>>files.
>>unless there is another program that can store tag info & export in
>>tab/comma delimited.[/color]
>[color=green]
>>"Chuck Grimsby" <c.grimsby@worldnet.att.net.invalid> wrote in message
>>news:32cmq1d1596vm09bgmdml4g5m0c36am8ct@4ax.com. ..[color=darkred]
>>>
>>> Mark, Are you trying to read in the MP3 tags off of MP3 files, or are
>>> you using the file names themselves?
>>>
>>> On Thu, 22 Dec 2005 21:42:04 +1100, "NoodNutt"
>>> <noodnutt@iprimus.com.au> wrote:
>>>>Thank you so much, between the 2 of you I managed to piece it together.
>>>>I would like to go 2 steps further if you can assist:
>>>>I think this is a big ask & will test you.. :-)
>>>>1. I need to copy a portion of text from 1 field to another. eg "Tom
>>>>Jones -
>>>>She's A Lady"... I would like to cut "Tom Jones - " delete the 2 spaces
>>>>&
>>>>dash then paste "Tom Jones" into the new field, structured in a loop
>>>>fashion
>>>>to do all records that match this type of criteria.
>>>>2. It would save me literally months of data entry if there was a way of
>>>>copying the "tag info" of each file, that which is displayed in the
>>>>windows
>>>>explorer.
>>>
>>>>"Terry Kreft" <terry.kreft@mps.co.uk> wrote in message
>>>>news:1EadnVEcB-HHvjreSa8jmw@karoo.co.uk...
>>>>> Whoops, slight error there piet. It should be as below except
>>>>> do while len(strname) > 0
>>>>> 'debug.print strname
>>>>> '--Write to table...
>>>>> rs.AddNew
>>>>> rs.Fields("FileName")=strname
>>>>> rs.Update
>>>>> strname = dir ' Get thye next one after you've written to the
>>>>> recordset
>>>>> loop
>>>
>>>>> <pietlinden@hotmail.com> wrote in message
>>>>> news:1135023972.054556.155700@o13g2000cwo.googlegr oups.com...
>>>>>> I've done this... essentially all you need to do inside the loop is
>>>>>> indicate where the data is going...
>>>>>> > '--specify where the information is going to go...
>>>>>> dim rsFiles as DAO.recordset
>>>>>> set rsFIles =
>>>>>> DbEngine(0)(0).OprenRecordset("MyDestTable",dbOpen Table)
>>>>>> '--Borrowed from Terry Kreft...
>>>>>> dim strName as string
>>>>>> strname = Dir("c:\*.*")
>>>>>> do while len(strname) > 0
>>>>>> 'debug.print strname
>>>>>> strname = dir
>>>>>> '--Write to table...
>>>>>> rs.AddNew
>>>>>> rs.Fields("FileName")=strname
>>>>>> rs.Update
>>>>>> loop
>>>>>> rs.close
>>>>>> set rs=nothing
>>>
>>>
>>> --
>>> Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing
>>>[/color]
>>[/color]
>
>
> --
> Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing
>[/color]
