re: Anyone ever interview for a job you didn't know you weren't qualified for?

Here's my guess:
The HR director's niece knows two releases of VBA and has SQL down cold. She has a minor in computer science and an MBA in systems.
You are just another resume they can claim to have interviewed before they give it to her.

I was offered an interview with the Coast Guard to be using a language I never took one course in. The ad on the USAJOBS website did not even spell out what language I would have to use. I had to call for that info. I guessed those suckers needed 2 more people so they could give the job to the pre-selected person.

if you see programming in the job description, ask about it next time.
did you take a course?
did you use it on the job previously?

HR is terrible at nuance. Do an extensive phone interview before you go that far next time.