0
python PYODBC ProgrammingError: ('42000', "[42000] [Microsoft][Pilote ODBC Microsoft Access]?
sql = """ update tableau as ori left join (select * from [C:/__tmp/test.mdb].param where zone = '1H005') param on ori.dep_sur = param.dsu_co set ori.texture = param.textu """ crsr = db.execute(sql) crsr.commit()
Apparently the SELECT ... FROM TableName IN "FileName" ... syntax is not available to ODBC queries from external applications. However, I just tried the following variation and it worked for me (Python 2.7 and pyodbc):
Thanks a lot, this works fine for me!
Discussion