I have a table called call_recordings, each record contains the details of each call that has been recorded.
It has it has a column called [audio_filepath], this contains the filepath of the corresponding call recording .wav file
e.g. 'C:\AM CR Data\DATA\Audio\31102008\20081031_105508_797_01_004.wav'
What i want to do is run a query and copy all the files into another directory e.g 'C:\Burning\CopiedRec\'
How would i go this?