Regular Windows CDs (with Joliet filesystem, which is the standard filesystem) will mount just fine. So a Mac (and practically any other OS I know of) can read windows cds. If you need to run a windows app, then that obviously won't work.
What kind of CD is it? Are you just looking for files or what?