Excel to SQL Server Import
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
Python, SQL, C# Programming, Microsoft SQL Server, Database Design · 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 ex