Autoplay. You know, like when you put a CD in the drive, it automatically plays whatever is on the CD?
If you can insert other disks into your drive, and they all autoplay, the problem is Civ3. If none of them do, then autoplay has probably been turned off, and you need to navigate to the CD drive in File Manager and double-click on the "setup.exe" file there.