Rapid input Via datasheet

I had a project where I had to input a large amount of redundant info using
temp help. For instance, I need to say a a particular type of Media was CD or
floppy. Another field required origin and so on. The fastest way we could do
this was to Highlight the cells on a Excel datasheet and do a fill down
command. Is it possible to do this with Access? I came up with a solution by
importing these spreadsheets, but I would like a more elegant solution and
eliminate the spreadsheets.