Facing Too Few Parameters. Expected 1. (-3010) (sqlexecdirectw)')" Error In Python Program

using python 'pyodbc' module for extarcting data from excel sheet. When I use numeric instead of win_b64, This program works, for string i.e. win_b64 It is showing below error. I w

Solution 1:

Answer :

excel = curs1.execute('''select [problem_name] from [Sheet1$] where platform_name = 'win_b64' ;''').fetchall() 

-> query syntax should be start in triple quot...and end too.