Is there a way to read CD table of contents?

[John_G]

Hi All -



Does anyone know if there is a way in MS Access to read the TOC data from an Audio CD? It is I believe in the lead-in part. I have a music database, and would like to be able to read the track data directly from the CD (Title, artist, timing), without having to type it all in again.

I know this can be done, because my CD labelling software extract the data automatically - but can Access do it?

Thanks

J.

[June7]

Will require VBA code. Should be no different from reading contents of any directory/folder. Here is one example http://allenbrowne.com/ser-59.html

[John_G]

Thanks Allen -

I am well versed in VBA, and I know that works fine for data CD's - but I am talking about music CD's, which are structured somewhat differently. When I use Windows Explorer to look at a CD, I see only a bunch of small files, Track1.cda,... etc.

I believe these are just pointers to the actual track data - but is it possible to use that pointer to access the actual track data (title, artist,...) using VBA?

Thanks

[June7]

Guess it is different then. I find some references to listing mp3 files by Google search: vb list music cd

Don't know if they can help.
http://webandmacros.net/excel-macro-list-files.htm