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.
Extended header section of parsable attributes, introduced by '#'. Header row of variable name and units for each column. Data rows. Depending on the presence of special keys in the extended header ...