Skip to content

[faq] fast_executemany does not work

Jump to bottom
Gord Thompson edited this page Jan 3, 2022 · 2 revisions

That's right. It doesn't.

pyodbc's fast_executemany feature depends on an internal ODBC mechanism named "parameter arrays" and the Microsoft Access ODBC driver does not support them, so fast_executemany simply cannot work with this dialect.

Related:

[pandas] faster alternative to .to_sql() for large uploads

Clone this wiki locally