title: How to use an input in python with sql
body: <p>I have this table in Windows Access:</p>
  
  <p>The title of my table is DATA</p>
  
  <p>NAME - GENDER - NUMBER</p>
  
  <p>Jo - Male - 1</p>
  
  <p>Ali - Male - 2</p>
  
  <p>MO - Male - 3</p>
  
  <p>I want to use an input that asks a name and I want my program to give the details of that person.</p>
  
  <p>I tried to do this:</p>
  
  <pre><code>import pyodbc
  
  conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};' +
  
          r'DBQ=C:\Users\Gebruiker\PycharmProjects\TennisDatabase.accdb;')
  gegevens = conn.cursor()
  question = input("Give a name: ")
  SelectString = 'SELECT NAME FROM DATA WHERE DATA.NAME = ' + question + ';'
  
  gegevens.execute(SelectString)
  gegevensList = gegevens.fetchall()
  
  
  print(len(gegevensList), "Spelergegevens : ")
  
  for gegevens in gegevensList:
      print (gegevens)
  print('')
  </code></pre>
  
  <p>I get this error:</p>
  
  <p>Traceback (most recent call last):
    File "C:/Users/Gebruiker/PycharmProjects/Opdracht 1.py", line 9, in 
      gegevens.execute(SelectString)
  pyodbc.Error: ('07002', '[07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (-3010) (SQLExecDirectW)')</p>
  
  <p>I have no clue what I am doing wrong and how to fix it.
  Can anyone help me how to do this?</p>