Need Office Pro 97/Access/FTP type help

[robleemn]

My mp3s are reaching 900 and out of hand and want to import them into an access database. When I try, access won't recognize the mp3s in file type extension. Wanted to look for "all" file types on office pro disk to add to access so mpe3 files would be recognized but when I run setup for office pro it says I have the office bar running and should exit the program first.

Am I on the right track or should I be trying an FTP procedure?

tia

[quaddawg]

I personally use FTP, I use Cute, its pretty good, as long as you know the FTP server of where you are going, should be a snap. That is if I understand what you are doing. Why not just get another hardrive?? It will take forever to upload that many songs even if you are on a lightning fast connection, what kind of transfer speed do you have to the database>??:

[Trigger351]

I fit about 200 mp3s on a CDR so all you need is a CD burner and some blank CDs, that way you get to keep them forever:)

[robleemn]

Just replied to your photo genie post. Quad, I have the songs downloaded on my harddrive already, I want to be able to search for a song by name as well as by artist and can't do that now. I want to make a "text" like database in access so can. I'm trying to get the "names" of my mp3 files into a database, not the songs themselves, so I was hoping to "import" with access so I don't have to type 900 file names and somehow "convert" the file type so it is not a link to the song. I don't know if this is even possible but I sure hope so.

[robleemn]

I'm doing that now, my harddrive crashed a while back and I lost a couple hundred songs. I have a delay in posting with a 56 dialup connection and morpheus/kazaa hogging up what little bandwith there is.

[RobPo]

Why not go to a command prompt (dos) (start | run | command), go to the root directory your MP3s are in and type

dir /s /b >mymp3s.txt

Then you only need massage the data - either use excel or something like that to save it as a CSV (use the - between artist and song name as the delimiter when you import the .txt file) then import it into access...

A herky way around it but should work.

[robleemn]

I did the stuff at the command prompt but when I opened the file with excel I got nothing. I checked the file properties which said "0" bytes used. Apparently nothing happened, but thanks, that is what I am trying to do.

At the desktop prompt I typed "rob's music" instead of mymp3s, would I be needing to get rid of the space in rob's music, get that in the prompt and type the command you listed letter for letter?[Edited by robleemn on August 19th, 2001 at 01:25 AM]

[robleemn]

Had trouble finding the right directory since my file was on the desktop, but looked for it and found BOB'SM~1. Never saw a directory like that before, but I then used your command AND IT WORKED! Thank you, thank you, thank you, you saved me many hours of grief!

[quaddawg]

Originally posted by robleemn
Just replied to your photo genie post. Quad, I have the songs downloaded on my harddrive already, I want to be able to search for a song by name as well as by artist and can't do that now. I want to make a "text" like database in access so can. I'm trying to get the "names" of my mp3 files into a database, not the songs themselves, so I was hoping to "import" with access so I don't have to type 900 file names and somehow "convert" the file type so it is not a link to the song. I don't know if this is even possible but I sure hope so.

Sorry, it was late and I misunderstood completely.

:D