One solution would be to rejoin (extract/append) all pieces of each title into a single, complete file. Maybe place the archive pieces in a different folder (if you find it necessary to keep the CD sized pieces), and scan the folder with the single-piece files into your database.
There are numerous free video editing programs that will append the pieces into a single file with ease.
Files are normally split into smaller pieces to make them portable, and more compliant with file server's limitations. But, once the set of files have reached their destination it is normal to re-compile the file for use.
Another solution would be to add these titles manually. Not by scanning their folder, but add them by title. This would eliminate the need to recompile them first.