Workaround for Access?

[Codein99]

Hey,

when I try to use panges with access I become this Error:

raise exc.CompileError(

sqlalchemy.exc.CompileError: The 'access' dialect with current database version settings does not support in-place multirow inserts.

Have someone a workaround for Access or something like this?

` dataframe = pd.DataFrame(data=[data])
columnnamespr = pr_DB.columns.keys()

dataframe = dataframe.rename(columns=dict(zip(dataframe.columns, columnnamespr)))
dataframe.set_index(['ID'], drop=True, inplace=True)

with engine.connect() as con:
    upsert(con=con, df=dataframe, table_name='produkte', if_row_exists='update', create_table=False, chunksize=1)`