.wav + database

Hello,
I have a folder with some .wav files and they all are named by numbers(10 digits). Then I have a database file with some info and one of the fileds of the database is called contacts and all are named with a number(10 digits).
How can I merge the .wav files to the database but also have each number match. Ex. If I have a .wav file called 1234567890 I would like to merge that file in the same line where contact: 1234567890 is. Any help would be apreciated.

note:this is for my work place and also for my knowledge. =)

Thanks!

If the wave file name is named the same as the number, then just read the record from the database, add ".wav" to the number, and then play the file (when the user clicks on play).

You don't need to import the file into the database, if that's what you are thinking when you say "merge".

Quote:

---

Originally Posted by CVMichael

If the wave file name is named the same as the number, then just read the record from the database, add ".wav" to the number, and then play the file (when the user clicks on play).

You don't need to import the file into the database, if that's what you are thinking when you say "merge".

---

I have a database file with some contacts info and we go by their phone number. I have a folder with voice massages wich our named by their number. How can I take those .wav files and import them into the databse.

field contact=1425 field wave=1425
field contact=2345 field wave=2345

I just don't want to look for the contact on the database and then open the folder and look for the wave file that matches that contact. I would like to have them all together.

If by 'import' you mean 'display a link to on the form', it's easiest to do what CVMichael said... take the field contact, and generate a file link to the path to the folder with the contact's number and ".wav" added to the end..

If you mean actually save the entire .wav file in the database itself, search the forum for GetChunk.