Home - gordthompson/sqlalchemy-access GitHub Wiki

Welcome to the sqlalchemy-access wiki!

Contents:

• Getting Connected
• FAQs, Tips, and Known Issues
  • [faq] fast_executemany does not work
  • [faq] field (column) type summary
  • [faq] support for Access_97 and earlier
  • [faq] upsert from DataFrame to existing table
  • [known issue] column names that contain question marks
  • [known issue] Incorrect reflection of columns' "nullable" status
  • [pandas] faster alternative to .to_sql() for large uploads
  • [pandas] specifying column (field) types for to_sql()
  • [pandas] to_sql() creates Long Text (a.k.a. Memo) fields for string columns
  • [pandas] .to_sql(… , method="multi") does not work
  • [pandas] working with 64 bit integer (BIGINT) values
  • [pandas] writing BLOB columns with to_sql()
  • [tip] create a new (empty) database file
  • [tip] create indexes on an existing table
  • [tip] running Access stored queries that expect parameters
  • [tip] use ExtendedAnsiSQL
  • [tip] using PyInstaller