[pandas] .to_sql(… , method="multi") does not work - gordthompson/sqlalchemy-access GitHub Wiki

The method="multi" option of .to_sql() wants to create multi-row INSERT statements, often in the form of a "table-value constructor", e.g.,

INSERT INTO table1 (col1, col2) VALUES (1, 'foo'), (2, 'bar')

and Access SQL does not support those.

If a plain .to_sql() (without method=) is too slow for a large DataFrame then consider the alternative approach documented here:

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