Import a Firebird 1 database to pandas dataframes, show a summary of the database table names, field names, field data types, and index columns, optionally extract and save table data to a directory, ...

Quite a few years back I wrote a post about reading CSV files in Power Automate. But that can be done so much better now. An imagine having to deal with commas, you would end up with ugly expressions.

A robust Python script that converts Excel (.xlsx, .xls) and CSV files to T-SQL INSERT statements, ready for execution in SQL Server or Azure SQL Database.