I have "scanned" film using a DSLR, it actually works quite well as long as you have something to keep the film square to your body, the same distance to your body, flat, something to easily advance the film and evenly lit. There is a plan for such a jig if you Google it and it wasn't hard to make at all. A macro lens would be ideal but a 50mm or longer prime with extension tube will work fine. Try to avoid a zoom (unless it's very sharp) because it will just add softness you don't want.

Or just get a scanner.

John.