Fleming describes James Bonds name as "the dullest name in the world", and as being "brief, unromantic and yet very masculine." Do you think the Bond novels would have been as successful, had Fleming chosen a different, equally, "dull" and "unromantic" name?
Would Sherlock Holmes have been as popular if Arthur Conan Doyle had chosen another name for his consulting detective? Probably.
007's name is just one small aspect of the books' and movies' success.
You start with a highly skilled writer and add a dashing hero, incredible archvillains, beautiful women and international intrigue, and you have a terrific recipe for success.
You can read the whole interview here.