Punched cards were used in computing centers for preparing batch mainframe jobs for submission.
Punched tape was more a hobbyist thing, as form of program storage and sharing, used in the era of early machines such as the Altair 8800.
You can still buy a copy of Microsoft BASIC on punched tape if you need it!