Excel to SQL Server Import

I have an advanced Excel workbook—between two and five sheets—filled with customer data that must live in Microsoft SQL Server. The columns include typical customer fields (name, contact details, account numbers, dates, notes), but a few calculated columns and drop-down validations make the file slightly more complex than a flat table.

What I need from you is a repeatable, fool-proof process that moves every row from the workbook into SQL Server while preserving data types, relationships and any necessary transformations (e.g., date formats, trimming extra spaces, converting text “NULL” to actual NULL). I’m open to whatever tool you prefer—T-SQL scripts, SSIS package, Python + pandas, or a lightweight C# utility—as long as it runs on Windows and I can rerun it whenever new files arrive.

Deliverables
• SQL Server table schema (CREATE scripts) matching the workbook
• Automated import routine with clear instructions (one-click SSIS package, .sql file, or executable script)
• Brief README explaining prerequisites, how to point to a new Excel file, and rollback steps

Acceptance criteria
• All sheets import without manual tweaks
• Record counts in SQL match Excel sheets exactly
• No data type mismatches or truncated text

If you’ve handled Excel-to-SQL migrations before, especially with multi-sheet customer data, you’ll find this straightforward. Let me know the approach you’d use and an estimated turnaround time.