In order to read an Acorn format CD you will need a different Mac, or a Windows/Linux PC, which does have an optical (CD/DVD) drive. You can then take an 'image' file of the contents of the CD, then transfer this image to the Mac and finally load the image file so that RISC OS treats it as though it was a 'real' CD.

This article covers the process in detail.

Did this solve your problem?