I have imported the path name of my mp3 collection to a table in Access through VBA. Now that I have the path name of the track what I would like to achieve now is to extract the section of the path that contains the artist name and the song title and put these into seperate Fields and save having to type this information for each path name
Possibly, my JET SQL isn't that up to speed.
However you could accomplish what you want to do using a VBA routine to read through every row in the column
look for the left most "\" and split at that point
update the row
move next until you reach the end of file
you could do it via a bound form with a command button to invoke the routine
You might want to put soem error checking to see if the artist was already set to stop overwriting valid artitis, AND / OR check the incoming field ended in ".MP3"
your misson, should you care to accept it.....