is it possible to import a music playlist to access

[johnmc]

I'm trying to bring some order to my music collection by creating a database,
is it possible to import/copy data from folders to access

 

[Klatuu]

Exactly what do you mean? do you want the file names in the folders or from
files in folders? If it is files, then what kind of files?
If it is file names in folder, then see the FileSearch Object in Access Help.

After thinking about it, I am guessing you will be browsing the folders the
music files are in and adding that to your table, right?

 

[johnmc]

Thanks for answering, what i would idealy like to end up with is a searchable
database with a link to wmp. AS i have just over 40Gb of music, which makes
finding one track quite a task

 

[Klatuu]

Sorry, I have not idea what a wmp is. Please give me an idea of what it is
and I can tell you exactly what you need to accomplish what you are after.

 

[johnmc]

sorry klatuu it's windows media player

Sorry, I have not idea what a wmp is. Please give me an idea of what it is
and I can tell you exactly what you need to accomplish what you are after.

 

[Klatuu]

Okay, got it.
Now, "Link To" - Where is it? are we talkiing files downloaded to your hard
drive?

If so, see my earlier post about the FileSearch Object. It allows you to
get a list of all the filenames in a folder.

Now, to store them, you need to have a field in your table that is hyperlink
data type. Once you use the FileSearch Object to get the list of files,
create a row in the table for each file and put the link to the file in that
field.

 

[johnmc]

Thanks Klatuu, i didn't know there was a file search option in access