Excel
Loading an Excel File Into SQLite With Python and the CLI
SQLite cannot read XLSX itself. Load a sheet through pandas to_sql or a CSV import, avoid type affinity traps and convert Excel serial dates.
7 min read
Tag
python
134 posts
Excel
Importing an Excel Sheet Into PostgreSQL With Python
Load an Excel sheet into PostgreSQL with pandas and psycopg: read as text, copy into a staging table, then convert types in SQL and keep a batch record.
7 min read